Click here to Skip to main content
15,916,527 members
Please Sign up or sign in to vote.
2.00/5 (2 votes)
How can I insert bulk data from an Excel file to Ms Access data base using OLEDB connection without using loops. I'm using OLEDB connection in a C# windows application?
Posted

1 solution

There is no bulk insert method for MS Access in the meaning of SqlBulkCopy[^] for Sql-Server.

Which means the answer to your question is: you can not.

If you need performance, MS Access is not the right choice. If you want to stick with MS Access, you will have to use loops. If you're willing to use DAO instead of OleDB you probably can gain some significant performance increase though, as this link suggests:
http://stackoverflow.com/questions/7070011/writing-large-number-of-records-bulk-insert-to-access-in-net-c[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900