How do I combine 3 tables into one?

[Steven Seagal]

I want to combine 3 tables into one table. Each table one after the other. So one table may have 300 records so the next table will have its first record on line 301. Fields are all the same throughout each table. How do I do this? Is automation possible?

[June7]

Is this a one-time event? How many records? You can simply copy/paste records. Otherwise, run an INSERT SELECT sql action.

[tanvi]

You can do it by append query. For example:


INSERT INTO Table1 (ColumnName) SELECT Table2.ColumnName FROM Table2


You would have to do that as many times as you have other tables to add to Table1.


There are many example on the net on how to create these queries.


Here are a couple of sites:


http://www.ehow.com/how_14047_create-append-action.html
http://office.microsoft.com/en-us/ac...860631033.aspx
http://www.databasedev.co.uk/append_query.html


Hope this will help..

[Steven Seagal]

Got it to work. Thanks All!