TransferDatabase and SQL Server

[Gordo]

I'm trying to use the TransferDatabase method in Access to
export data from TableA to a table in a SQL Server db, but
I'm having trouble making the connection. I'm using an
example from the Access Help for exporting to ODBC
databases, but this doesn't seem to work. Does anyone
know how to do this?

Thanks in adv.
Gordo

 

[Thomas L. Ickes]

I'd go the other route (if you can). Try using the import/export wizard in
SQL Server Enterprise Manager.
Simply right-click just about anywhere and under All Tasks you will see
Import.

p.s. If you cannot hit it, perhaps you do not have permissions on the server
(which could be your connection problem).