Mutlitple Tables that need to be consolidated into one

[alexaronson]

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.

 

[pritcham]

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]

If you use Martin's first suggestion you won't actually get duplicates, unless you specify to include ALL records from the tables.