In Tip 824 Diane Poremsky shows us a bit of VBA that lets you add photos to your contacts in bulk. Let's try and improve the code.
Continue Reading: Add photos to Contacts in bulk using VBA in Outlook »
Pushing and Pulling Access around
July 24, 2009 by · 
In Import data to Access from Excel and My first Access macro, I posted some Access macros that push data into Access. Here is some code that does both.
Continue Reading: Pushing and Pulling Access around »
Conditional Import Text Files
August 26, 2008 by · If you have a text file to import, but only need some of the data, you could just import the whole thing and then manually scrub the data to find what you want. Text files can contain a lot more lines than an Excel worksheet, but much of it may be fluff. Here's a method for importing only the data you need.
Continue Reading: Conditional Import Text Files »
Import data to Access from Excel
February 4, 2008 by · Back in January, I promised to post a macro that imports data from Excel into Access programmatically.
Continue Reading: Import data to Access from Excel »
My first Access macro
January 18, 2008 by · I wrote my first Access macro today! Now, I am not a big fan of Access, but unfortunately I have to use it at work because it is the first choice for most people looking for a db (short for "database") program. For most situations, I prefer Excel.
Continue Reading: My first Access macro »
Follow Me