copying data from datatable into Access table

V

VMI

I have a filled datatable and I need to copy this data into an Access table
with exactly the same table structure. Can I do this without having to run
an Insert query for every line of the datatable? also, I'll be doing this
several times (I'll have several datatables that will be copied into the
same Access table) so I would have to need to append to the existing Access
table. If the table in Access doesn't need to be created (ie. copy datatable
schema and data into Access), then much better.
Is this possible?

Thanks.
 
M

Miha Markic [MVP C#]

Hi,

You'll have to do an insert per row.
The best way is to use OleDbDataAdapter which does it for you - you have to
configure it, though.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copying datatable data into MS Access table 1
copy data from one datatable to another - different schemas 2
Adding datatable data to sql database. 1
DataTable Subset to new DataTable 1
Copying records from datatable to datatable in dataset 1
Dumping datatable to MS Access table 2
Dumping datatable into Access table 1
datatable 2

Top