Combining 2 Tables

C

carl

I have 2 tables in the same database. They are both set-up with the same
columns. Is there a way to combine them into 1 table ?

Thank you in advance.
 
E

Eric @ CMN, Evansville

Write an append query to take data from one table and append it to the
other....then you can delete the table that is incomplete.
 
C

carl

thank you. and how is that done ?

Eric @ CMN said:
Write an append query to take data from one table and append it to the
other....then you can delete the table that is incomplete.
Click to expand...
 
E

Eric @ CMN, Evansville

In SQL the append query should look something like this:

INSERT INTO table2 ( field1, field2 )
SELECT Table1.field1, Table1.field2
FROM Table1;

Where your table names and field names are inserted appropriately. Then you
could copy and paste the SQL into a new query (after you switch to SQL view,
of course). After that you could switch back to design view to see the SQL
represented graphically.

Hope this helps !
 
Top