importing records into access table through SQL

[marcvanderpeet12]

Dear all,



I'm looking for a way to insert records into an access table through SQL. I know you can insert one record by "INSERT INTO "TABLE" (...,...,..) VALUES (...,...,...) but i cant find a way to insert multiple records at the same time... Anybody a way?

[euanl]

Insert into should work

INSERT INTO Table1 (Field1, Field2......)
SELECT Field1, Field2.........
FROM Table2

[amrut]

Create an append query and call it through VBA