copy table from one database to another

R

reidarT

I have 2 backend-databases and 1 front-end
I would like to copy a table from backend database 1 to backend database 2.
The unique field is an autonumber field and I need the same unique values.
If I use the copyobject method I get a linked table in backend database 2.
reidarT
 
A

Arvin Meyer [MVP]

reidarT said:
I have 2 backend-databases and 1 front-end
I would like to copy a table from backend database 1 to backend database 2.
The unique field is an autonumber field and I need the same unique values.
If I use the copyobject method I get a linked table in backend database 2.
Click to expand...

Then add code to build a Make-Table query, or do it in SQL (Create Table)
and append the records. You can also use the TransferDatabase method, or
simply import the table using the GUI (File ... Get External Data ...
Import)
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Top