TransferDatabase code needed

[marathonlady]

Could somebody give me the code for the transferdatabase docmd? I get the message that it can't find the database I want to export from.

Thanks.

 

[apr pillai]

TransferDatabase

Try This:

DoCmd.TransferDatabase acImport, "Microsoft Access", "d:\e\mdb\SourceDB.mdb", acTable, "SourceTableName", "TargetName", False