Saving bulk data into acces

  • Thread starter Thread starter G Uljee
  • Start date Start date
G

G Uljee

Hi,



I've an application with an Access database (max 10000 records).

I want to save per 1000 records at once into the Access database, witch
option do you prefer (example)?

Someone experience with saving bulk data?



Cheers Gaby
 
Gaby,

I think that the only way that you are going to be able to do this would
be to craft your own SQL statements which are all appended to each other and
then execute it at once. However, this might put a lot of strain on the
OLE-DB provider (since it is working your process space) depending on the
number of operations you are performing.

Hope this helps.
 
Back
Top