Hi, all,

Wondering if this can be done.... Is there a way to insert data from one oledbadpter to another?

For example:
1) I have a connection to one datasource and a file (comma delimited file) loaded into a dataadapter1(1.)

2) I would like to take this file and using another dataadapter(2) and data source, load it into a dataset.

3) Then I would like to call the update method (second dataadapter) to save these changes back to the database.

Also, after the update method is used to update the database, does the datatable clear itself or do I need to clear it out if I want to repeat the same process for another file?

Thanks,

Strick