Query multiple tables into a nother table 2

[np3il]

Query

Is there a way to read data from more than one table with the same Layouts and append the data as one table?

In better words:

Merging two tables into another table.

Any suggestions are appreciated.

Thanks

Np3il

 

[mp9]

If you have two tables, tbl1 and tbl2, which are of exactly the saem structure and you want to combine them into 1 new table, tblNew, try this:

SELECT * INTO tblNew FROM (SELECT * FROM tbl1 UNION SELECT * FROM tbl2);

Hope this helps.

http://www22.brinkster.com/accessory/

 

[Crowley16]

an append query?

or insert select query?

--------------------
Procrastinate Now!

 

[np3il]

The code put it in prespective but:

Is there a way to do this in MS-Access | Query?

Thanks
np3il

 

[lespaul]

switch to the SQL view of a query, paste the SQL, modify to the correct table names, run the query. You'll need this modified SQL probably:

SELECT A.* INTO tblNew FROM (SELECT * FROM tbl1 UNION SELECT * FROM tbl2) As A;

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

 

[np3il]

Thanks for the suggestions it worked very well.

Best Regards

np3il