Bulk Insert (ADO/Access2000)
-
I would have to insert around 500 records every 10 seconds into a table in Access 2000. I am using ADO. What is the most efficient way to do this with good performance. Is it possible to pass all of the 500 records to a query using some kind of SafeArray parameters and Insert them all at once? Any tips how this can be accomplished ? Thanks
-
I would have to insert around 500 records every 10 seconds into a table in Access 2000. I am using ADO. What is the most efficient way to do this with good performance. Is it possible to pass all of the 500 records to a query using some kind of SafeArray parameters and Insert them all at once? Any tips how this can be accomplished ? Thanks
-
I think stored procedure is the best way. Mazy **"If I go crazy then will you still Call me Superman If I’m alive and well, will you be There holding my hand I’ll keep you by my side with My superhuman might Kryptonite"**Kryptonite-3 Doors Down
Could you please help me in with a small sample code. Do I have to send the records as an array and loop the INSERT statement for all records? I am not quite sure if all this is possible in ACCESS. I guess my question would be can I pass an array to Stored proceedure, if Yes how? Thanks for your time.