Import from ODBC in macro or VBA

[heathlovell]

Hello,
I would like to write a macro or VBA module to import a table from an ODBC source. Can anyone help me with this?
Thanks,
Heath Lovell

 

[SoloDroid]

Hello Heath,
Here is the code that you require. Simply place it in a VBA module:

DoCmd.TransferDatabase acImport, "Microsoft Access", "[c:\myfolder\db1.mdb]", acTable, "[Table1]", "[Table1]"

Or for ODBC databases:

DoCmd.TransferDatabase acImport, "ODBC Database", "ODBC;DSN=[MyDataSource];UID=[UserName];PWD=[Password];LANGUAGE=us_english;DATABASE=[MyODBCDatabase]", acTable, "[Table1]", "[Table1]"

Simply replace the text in the square brackets [], and be sure to discard the square brackets as well.

Good Luck,
Robert Professional, affordable, Access database solutions and assistance

http://www.SoloDroid.com