How can I use c#/vb.net to bulk insert a datatable into an access db table?

[Hemanth_Kumar]

Collection data containing 5000Rows x 30 Columns needs to be passed as data table(dt) into code stage and that dt needs to be inserted into MS Access DB using either C#/VB.net/ or any other way. Thanks in advance.

------------------------------
Hemanth Kumar
ASE
Accenture
Europe/London
------------------------------

[bruce.liu]

Hi Hemanth,

MS Access does not offer a way to bulk insert records. Supply arrays as parameters to the query may be the way to go. Recommend you take a read on the following StackOverflow article:

https://social.msdn.microsoft.com/Forums/en-US/1256c0c0-f836-4a5c-8772-c3001839d052/bulk-insert-in-ms-access?forum=adodotnetdataproviders

------------------------------
Bruce Liu
Senior Product Consultant, Professional Services
Blue Prism
Australia/Sydney
------------------------------