topic How can I use c#/vb.net to bulk insert a datatable into an access db table? in Product Forum https://community.blueprism.com/t5/Product-Forum/How-can-I-use-c-vb-net-to-bulk-insert-a-datatable-into-an-access/m-p/67350#M19955 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.<BR /><BR />------------------------------<BR />Hemanth Kumar<BR />ASE<BR />Accenture<BR />Europe/London<BR />------------------------------<BR /> Thu, 08 Jul 2021 01:38:00 GMT Hemanth_Kumar 2021-07-08T01:38:00Z How can I use c#/vb.net to bulk insert a datatable into an access db table? https://community.blueprism.com/t5/Product-Forum/How-can-I-use-c-vb-net-to-bulk-insert-a-datatable-into-an-access/m-p/67350#M19955 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.<BR /><BR />------------------------------<BR />Hemanth Kumar<BR />ASE<BR />Accenture<BR />Europe/London<BR />------------------------------<BR /> Thu, 08 Jul 2021 01:38:00 GMT https://community.blueprism.com/t5/Product-Forum/How-can-I-use-c-vb-net-to-bulk-insert-a-datatable-into-an-access/m-p/67350#M19955 Hemanth_Kumar 2021-07-08T01:38:00Z RE: How can I use c#/vb.net to bulk insert a datatable into an access db table? https://community.blueprism.com/t5/Product-Forum/How-can-I-use-c-vb-net-to-bulk-insert-a-datatable-into-an-access/m-p/67351#M19956 Hi Hemanth,<BR /><BR />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:<BR /><BR /><A href="https://social.msdn.microsoft.com/Forums/en-US/1256c0c0-f836-4a5c-8772-c3001839d052/bulk-insert-in-ms-access?forum=adodotnetdataproviders" target="_blank" rel="noopener">https://social.msdn.microsoft.com/Forums/en-US/1256c0c0-f836-4a5c-8772-c3001839d052/bulk-insert-in-ms-access?forum=adodotnetdataproviders</A><BR /><BR />------------------------------<BR />Bruce Liu<BR />Senior Product Consultant, Professional Services<BR />Blue Prism<BR />Australia/Sydney<BR />------------------------------<BR /> Thu, 08 Jul 2021 02:22:00 GMT https://community.blueprism.com/t5/Product-Forum/How-can-I-use-c-vb-net-to-bulk-insert-a-datatable-into-an-access/m-p/67351#M19956 bruce.liu 2021-07-08T02:22:00Z