Yes - with an "append query"
You can either write the SQL Insert statement yourself
INSERT INTO Table1 (Field1, Field2)
- or you can get Access to do it for you, by selecting "APPEND" in the query type.
There are 10 kinds of people in the world - those who understand binary - and those with friends