which would be faster?

[djc]

I 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?

Thanks in advance.