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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing XML Data in Access 2003 1
Snowflake to SSIS 0
Auto update of Access DB from 3 other Access Databases 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Basic import into Access; set it up to grow dynamically & link tab 1
Import Excel 2010 table into Access 2010 - not listed as range 1
XLS Spreadsheet Import to Access 2007 being rearranged 5
'Created By' names are now numbers in Access 2007 10

Top