Access to Access

A

AGOKP4

hi,

how can i import data from one access db to another, I need all the data in
the same table. The data are similar, only difference is the ID number. I
tried importing a couple of times but kept getting them in new tables.

Thanks!!
 
J

Jeff Boyce

You can "link" to tables in other databases.

You can import data and (chose to) append it to an existing table.

You can import data and create a new table.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
K

Klatuu

Link to the table in the external database
Create an append query that will append the records to the existing table in
your local database.
Run The query
Delete the link.
 
J

Jeff Boyce

You haven't mentioned which version of Access you are using...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top