Saving bulk data into acces

[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

 

[Nicholas Paldino [.NET/C# MVP]]

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.