TransferDatabase Method

[Terry]

Hello,
I am using the following code to import a table from an
ODBC datasource and is working fine:

DoCmd.TransferDatabase acImport, "ODBC
Database", "ODBC;DSN=MYODBCCon;", acTable, strTableName,
strTableName, 0, 1

Now, I do not want to bring this table into my current
database, but have the destination be an external
database. I have tried using the full path in
the 'destination' part of the method, but it still imports
into my current db. I cannot use this method in the new
destination because I am going to 'Create' the .mdb,
import the tables, then 'Kill' the .mdb when finished with
the data.

Any help with this Method syntax to accomplish this would
be appreciated.

Regards,
Terry

 

[david epsom dot com dot au]

You can't do it that way. Instead, just use a SQL
query to do it:

db1.execute "select * into [db2].[t2] from [db3].[t3];"

(david)