How do I append one table to another.
I assume I'll have to use insert but I'm stuck from there.
:)
Printable View
How do I append one table to another.
I assume I'll have to use insert but I'm stuck from there.
:)
Insert..Select
Insert table1
select * from table2
will move the contents of table 2 into table1. The tables need to posses compatible data types and structures