Access tables

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

Guest

I have several tables of information that is duplicated. Is there any way
that I can merge this information into one table and not have duplicates
please.
Regards. S
 
Create a union query, and use that to create a Make-Table query.

SELECT Field1, Field2 FROM Table1
UNION
SELECT Field1, Field2 FROM Table2
UNION

SELECT Field1, Field2 FROM Table3

UNION will eliminate duplicates: UNION ALL won't.
 
Hi
I am probably more muddled than I think. All these tables are in separate
DBs. I think that these need to be consolidated first?
Regards.
S
 
You could Link them, or Import them before following Doug's suggestion.
Importing and Linking both begin with "Get External Data" on the File Menu.

Larry Linson
Microsoft Access MVP
 
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

Best solution to merge multiple Outlook contacts easily 2
UNION QUERY.. 3
Please help - I need to separate data to two tables using one form. 0
Updating tables when you input new data 0
Avoiding Duplicates 1
Duplicate values in the index, primary key, or relationship messag 2
Simply Merging ten tables 1
Duplicates appearing on report - Access 2003 1

Back
Top