What is the easiest way to run an MS Access macro from VB6? I can connect to the MDB and query the tables and run queries, but I need to import 100000+ rows into a table. I created a macro that imports the data into a table and it runs fine. But how do I run this macro from VB6? Is it possible to do this without creating a reference to the Access object? Users of the application may not have Access installed on their machines. To load the data one record at a time using an insert statement takes almost an hour, where the import macro takes a few minutes.