MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excell Macro


Posted by Gary G on January 30, 2002 11:44 AM

I need to create a macro that will import data from a ACCESS database table. How can I do this?

Thanks


Posted by Larry on January 30, 2002 11:54 AM

***** You can simply go to Data -- Import External Data, then create a direct link in to the Access file. You can then set the options to have this updated every time you open the file or on demand. You can also retrieve from tables and queries in Access.