Mutlitple Tables that need to be consolidated into one

alexaronson

Active Member
Joined
Sep 30, 2005
Messages
314
I have multiple tables that happen to have all the same fields titles. Each table is over 100,000 rows.

Can anyone help give me direction on how I can combine the tables?

Thanks,

An Access Newbie.
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

pritcham

Board Regular
Joined
Oct 26, 2005
Messages
128
Hi

Assuming you're not concerned about introducing duplicates etc (if any exist in different tables for example) then you've got a couple of options:

1) Take a look at producing a UNION query (see the helpfile) that unions all the different tables - you could use the results of this query to generate a new table if you want.

2) Take a look at running Append queries (again, in the helpfile) to append all the details from the extra tables on to which ever you designate as being your 'master table'.

Hope that helps
Martin
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,047
Office Version
  1. 365
Platform
  1. Windows
If you use Martin's first suggestion you won't actually get duplicates, unless you specify to include ALL records from the tables.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,025
Messages
5,569,727
Members
412,289
Latest member
Kingchaos64
Top