Import data to Access from Excel

Monday, February 4th, 2008 1,059 views

Back in January, I promised to post a macro that imports data from Excel into Access programmatically. (See My First Access Macro.) It takes a given spreadsheet and imports it into a given Access file/table. The spreadsheet must have a header row, with no blank rows or columns inside the table block. ...

Posted in Access, Excel, VBA, automation | 2 Comments »

My first Access macro

Friday, January 18th, 2008 102 views

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. At work I ...

Posted in Access, Excel, VBA | No Comments »