>>Check the syntax of «Insert Into». You can do this using a single SQL query.
>
>Ok, here's a dumb question. Look it up where? MSDN only shows the T-SQL Insert, do I use that, or is there a specific help file for the JET OLE-DB provider?
>
>IAC, INSERT INTO requires the table to exist, correct?

You can use SELECT INTO if the table does not exist.