Insert from one oledbadapter to another

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

This is the sort of stuff that doesn't need asking. Set up a small test app and try it for yourself. You learn most by doing so this will not only give you the answer to your current question but give you practice at problem solving.