How do I combine databases?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several database with identical fields that I want to make ino one
database, okay for duplicates.
 
Open one of the databases do the following
File/Get External data/Link tables
select on of you other databases
select the table
Click ok

if you already have a table the same name the linked one
will be identified by having a (1) Aappended to it. It
will also have an arrow next to it.

Create and append query appending the newly linked table
records to the existing table in your db.

Chris
 
You must log in or register to reply here.

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

Combing databases 1
Appending Linked Data 3
Database for email contact addresses 1
Importing Date/Time fields 3
Combine tables 2
How to link multiple excel spreadsheets to a single access db? 1
Access Skip address field if previous field is blank 2
Merge databases in Access 2007 1

Back
Top