Dumping datatable to MS Access table

[VMI]

How can I dump a datatable into an Access table (which contais exactly the
same structure)?
Somebody suggested doing this with a dataAdapter. I don't want to run an
Insert query for each record (I assume that if the datatable and the Access
table have the same structure, I can just dump it from one place to the
other). I'd be dumping data to the same Access table several times (append).

Thanks.

[Brad]

Look into merging DataSets. Then using the data adapter to update the
Access database with the merged DataSet.
"VMI" <vo******@yahoo.com> wrote in message
news:Ok**************@TK2MSFTNGP09.phx.gbl...

How can I dump a datatable into an Access table (which contais exactly the
same structure)?
Somebody suggested doing this with a dataAdapter. I don't want to run an
Insert query for each record (I assume that if the datatable and the Access table have the same structure, I can just dump it from one place to the
other). I'd be dumping data to the same Access table several times (append).
Thanks.

[VMI]

Thanks for the reply.
If I have the datatable filled up, what data adapter method would I use to
do this? Basically, I'll be running a loop that'll continuously fill the
datatable. Then every 100 records, I want to dump the datatable data into
the Access table and delete the DataTable's data, which will be filled up
again with another 100 records . Why would I need to merge the dataset?

Thanks.
"Brad" <no****@nowhere.net> wrote in message
news:10*************@corp.supernews.com...

Look into merging DataSets. Then using the data adapter to update the
Access database with the merged DataSet.
"VMI" <vo******@yahoo.com> wrote in message
news:Ok**************@TK2MSFTNGP09.phx.gbl...

How can I dump a datatable into an Access table (which contais exactly the same structure)?
Somebody suggested doing this with a dataAdapter. I don't want to run an
Insert query for each record (I assume that if the datatable and the

Access

table have the same structure, I can just dump it from one place to the
other). I'd be dumping data to the same Access table several times

(append).

Thanks.