recordset and vb, the faster ?

[ZeuBug]

i have a temporary recordset with 1000 records and i want to put all records in a access records, not an update but an insert,what is the faster and can i send the recordset directly to the access record

thanks [sig]<p>Raph<br><a href=mailto:rchene@rockefeller.univ-lyon1.fr>rchene@rockefeller.univ-lyon1.fr</a><br><a href= > </a><br> [/sig]

 

[VB400]

What exactly is this &quot;temporary recordset&quot; and where is it coming from?
Is it an ADO recordset or do you mean a text file?
Do you basically want to take that data and write it to a new Access table?

Please elaborate a little more! [sig]<p> Tarek<br><a href=mailto:tarek@regalsystems.net>tarek@regalsystems.net</a><br><a href= > </a><br>The more I learn, the more I need to learn![/sig]

 

[Guest_imported]

it s a new ado recordset i have created (with data from a file text).
i have extract the data from the text file and in a second time, i want to insert the data which are on my ado recordset, into an existant access table.

and i want to know if i must insert record by record or if i can send all my ado recordset into the access table.

Thanks