I am trying to import a table from an access db file. The user will pick the file through the GetOpenFilename application, which seems to be working. I have recorded a macro to open an ODBC connection to an Access db, which also works. The macro fails when I try and use the filename path. Any ideas on how to fix the table import macro or another way to accomplish the import?

Many thanks!

Please Login or Register  to view this content.