Append tables

[frank ashley]

How do I append one table to another.

I assume I'll have to use insert but I'm stuck from there.

:)

[JHausmann]

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