need to add what could be in some cases a large number of records to a
table all in one operation. It would be from an access front end linked to
sql server2000 backend table (jet-connected ODBC).

I will be keying off of one field in one recordset to use as the key field
in the new records I need to add to the backend table.

which would be faster:
A. loop through my recordset and .addNew each record individually directly
to the BE table.
OR.
B. loop trough my recordset and create a local table. Then do some kind of
mass append operation?
OR
C. NO looping through recordset. Maybe an INSERT INTO or some kind of make
table query would be best? Then append the whole table to the target table?

Thanks in advance.