copying data from datatable into Access table

[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.

[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.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"VMI" <vo******@yahoo.com> wrote in message
news:uX**************@TK2MSFTNGP10.phx.gbl...

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.