Combining 2 Tables

[Guest]

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.

 

[Guest]

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.

 

[Guest]

thank you. and how is that done ?

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.

 

[Guest]

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 !

 

[Smartin]

thank you. and how is that done ?

:

You could try

INSERT INTO Table1 SELECT * FROM Table2

You may have problems with keys, in which case you would need to modify
the SELECT clause to exclude the key field.