Insert data from multiple tables into one table

[mohanmoni]

Hi,

Need query to insert data from multiple tables into one table matching with column names.
(Note: Column positions are not same in all the table, it's completely differ.
Like... Table1 - Contactname, company, address, city, state, zip, country.


Table2 - City, state, company, contactname, zip, country, address.

Thanks.

[June7]

Why are you duplicating data between tables? This is contrary to basic relational database principles.

[NTC]

you have to decide on the field/column names that are to be used for the final table - - and then you have to map the name variations to the final table names as part of the consolidation. The consolidation is nothing but Append Queries. But the order of the column/fields do not matter - only variations in their names. So set up AppendQueries and manually select the correct field to append into i.e. LName goes into LastName.... that sort of thing.....

[June7]

Okay, if this is a one-time exercise to consolidate multiple tables into one then as NTC notes, can append records. Use INSERT SELECT. Or if not too much data, copy/paste records - just have to make sure fields are in the same order.