Hey. I'm trying to merge many tables into one in Access but not quite sure how to go about it. Can anyone help me?

There are lots of ways to do that.

What do the tables look like and how are they going to be merged?

Can you do it in Excel?



mmcdonal

There are 13 tables with about 80 addresses in each and i need to make it into one big table. How would i do it in excel?

peace be upon you Charlotte89 and every reader

In order to merge several tables into one table there are two ways
    1-"Vertical merge" if the small tables have the same field names so you can merge them by an action query like the Append Query. Just create a copy of one of the tables (to be the core of others), then create an append query for another smallTable and execute it then change then name of the smallTable in the SQL view to the next one and so on.
    2-"Horizontal merge" if the small tables have different field names but only one common field, so merge them by making a relational Select query.

Best regards

Dr. Mohammad El-Nesr
Irrigation Systems Design Specialist

Did you get this resolved? I have been out of work for several days and am catching up.

mmcdonal

use an append query then create a new table and append the table from the other tables, excel can pull from the new table OR create a query that queries all tables