Monday, February 4th, 2008 645 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 | No Comments »
Thursday, January 31st, 2008 17 views
Here is the revised and completed code that I posted yesterday. The DAO declarations are moved outside the Sub procedure and the 'Set' statements are outside the function loop. Also, the table & column headers are now passed as arguments to the function, making the code more compact. The speed ...
Posted in Access, Excel, VBA | No Comments »
Wednesday, January 30th, 2008 37 views
Finally, with some help from the good folks over in the microsoft.public.access.modulesdaovba newsgroup, I was able to complete my code to search an Access database for some information stored in an Excel worksheet.
This code will cycle through a list of numbers in column B, starting in cell B2, then check ...
Posted in Access, Excel, VBA | No Comments »
Friday, January 18th, 2008 66 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 »
