Import ODBC table

M

McLean J

I am trying to write a macro that will use the "TransferDatabase" feature to import an ODBC table.

I have attempted to place this text in the DatabaseName field but no luck... get an error...

Driver={SQL Server};Server=srvName;UID=ID;password=PAss;database=dbName

any idea how to make this work?
 
Top