which is better for inserting new records.

  • Thread starter Thread starter Jesper F
  • Start date Start date
J

Jesper F

I'm wondering -
which is better/faster/safer when inserting new records
with varying values into a table through code.

Using rs.addnew... rs!value...rs.update
or
a loop with a series of db.execute(INSERT INTO..) commands?
Thanks for any input.
 
I'm wondering -
which is better/faster/safer when inserting new records
with varying values into a table through code.

Using rs.addnew... rs!value...rs.update
or
a loop with a series of db.execute(INSERT INTO..) commands?
Thanks for any input.
Click to expand...

By far the fastest would be a single Append query, if that's feasible.
If you can only insert one record at a time, I'm not sure which would
be preferable - maybe you could try it and tell us all!
 
Back
Top