Hi I would like to know what is the best way to insert records in a table
when this table contains already a large number of records
I mean, let's consider we have a table that contains 100,000 records and i
want to insert a record into it.
what is the best way to do this:
open the recordset like this
rs.open tablename,connection, .....
or rs.open "Select * from table where (a condition that returns me an empty
or there is other better ways
Please if somebody can give me some recommendation it will be very helpfull