Hello,
I am working with Access 2007. I am fairly new with it.
I need to combine multiple tables into 1 having identical fields into a single table.
Is there any simple & easy way to do so?
Hello,
I am working with Access 2007. I am fairly new with it.
I need to combine multiple tables into 1 having identical fields into a single table.
Is there any simple & easy way to do so?
You use an Append query. Make a structure only copy of one of the tables (use Copy and paste).
Then add the identifier.
Now run Append queries for each table into the new main table.
- Make a new empty table or choose the existing table to be the central repository of the data.
- Make a query for all field and records for the first table. Change the query type to Append and select the destination table as the target.
- Execute the query
- Delete the source table and replace with the next
- Repeat the procedure until all source tables have been used.
Hi
You need to establish a relationship between the tables. This is really simple in Ms access. You can drag and drop fields from one table to the other to create the relationship.
http://office.microsoft.com/en-us/ac...963201033.aspxCode:SELECT TableA.PrjectNumber, TableA.DVD#, tableb.BobNumber FROM tableA INNER JOIN tableB ON TableA.ProjectNumber = TableB.ProjectNumber;
You can also do a UNION select. SELECT * FROM TABLE1 UNION SELECT * FROM TABLE2 etc.
Bookmarks