Hi-

I'm trying to import a table from one database to the current database. The table I wish to transfer from has the same format as the one I'm importing to, but the names differ.

I can't seem to get it to change names- it always creates a new table of the same name as the "from" database...

Any help?

DoCmd.TransferDatabase acImport, "Microsoft Access", "path\file.mdb", acTable, "tablename", "newtablename", False

I used this and it works fine, is this the format you are using to transfer the table?

All but the "false"- I tried it with the false, and it still created a new table in my current database...

DoCmd.TransferDatabase acImport, "Microsoft Access", transpath, acTable, "AgCentral1", "AgCentralData", False

agtrans = c:\agris\trans\agtrans.mdb

[This message has been edited by belton (edited 05-18-2001).]