mapping 2 or more table /merging tables

G

Guest

I have multiple databases that I would like to merge in to one.

In some cases the field names are different such as fname versus firstname,
other fields have common names brtween the tables/databases.

What is the best way to map fields and import the data?

Thanks

Rob
 
J

John Nurick

Hi Rob,

In the "one" database, use File|Get External Data|Link to create a
linked table connected to a table in one of the other databases.

Then create an append query to move the data from the linked table into
the table where you need it, mapping the fields as needed. If necessary
you can use calculated fields in the append queries to reformat or
otherwise modify the data.

Repeat as necessary for other tables/databases.
 

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

Top