p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access (http://p2p.wrox.com/forumdisplay.php?f=18)
-   -   Merging Tables (http://p2p.wrox.com/showthread.php?t=50027)

Charlotte89 November 8th, 2006 09:21 AM

Merging Tables
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?

mmcdonal November 9th, 2006 04:19 PM

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?


Charlotte89 November 10th, 2006 08:33 AM

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?

drnesr November 13th, 2006 05:49 AM

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

mmcdonal November 14th, 2006 08:56 AM

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


gigaboy November 22nd, 2006 12:49 AM

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

All times are GMT -4. The time now is 04:50 AM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.