I suggest you look at DoCmd.TransferDatabase. This should get you what
you want.

DoCmd.TransferDatabase acImport, "Microsoft Access", _
"Path and Name of DB", acTable, "Name of Import table", _
"Name of table to put in"

Note that this will create an identical table to the one that is in the
first db and so you should not have a table created in the new db.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/