Access to Access

  • Thread starter Thread starter AGOKP4
  • Start date Start date
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!!
 
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
 
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.
 
You haven't mentioned which version of Access you are using...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top