Dumping datatable to MS Access table

V

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

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

Brad

Look into merging DataSets. Then using the data adapter to update the
Access database with the merged DataSet.
 

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
Dumping datatable into Access table 1
copying data from datatable into Access table 1
Adding datatable data to sql database. 1
How To Insert DataTable Into MS Access (Record at a time too slow) 4
DataTable Subset to new DataTable 1
copy data from one datatable to another - different schemas 2
Copying records from datatable to datatable in dataset 1

Top