Copy a table to another database

[matterhorn]

I am trying to copy a table and it's contents from it's existing location to another .mdb file

Any ideas on how to accomplish this? Please let me know if more clarification is needed.

Thanks,

Matt

 

[PHV]

Have a look at the DoCmd.TransferDatabase method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[wdverner]

You may also want to use the import facilty. In the database you wish to import TO:

right click the tables objects,
Select Import
Change File types to MDBs
Navigate to the MDB you want to copy FROM
Highlight and click OK.
Browse to the tables,
Highlight the table and select ok

It will then copy the table and data into your DB.