Copy Tables from two different databases 1

[mishbaker]

Ok, I've been trying to implement a sort of "import/export" featre into a database. I would like to take the tables from a database and import them into my current DB's backend. (that just sounds dirty).

Maybe open a workspace and then open the two databases?

I need to keep the "autonumber" in tact as well as the other information.

All lessons learned from the School of Hard Knocks........at least tuition is cheap.

 

[PHV]

You may consider 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

 

[mishbaker]

Can that get a table from a "third" db to my backend?

All lessons learned from the School of Hard Knocks........at least tuition is cheap.

 

[mishbaker]

Duh! Nevermind! Thanks for your help.


All lessons learned from the School of Hard Knocks........at least tuition is cheap.