Inserting DataSet into Access Table

[stevec]

I have an application that reads a xml file into a DataSet. I can see the DataSet has the table name and proper column names and values. I am searching for a way to insert this entire DataSet into an MSAccess table. I have been using the OleDBAdapter, but this appears to be more useful for loading a DataSet from a table and modifying it. Any help is greatly appreciated.

[ITGURU]

Hello Steve,

You can use "InsertCommand" property of the OleDBDataAdapter for defining the insert SQL Statement and then execute following statement for inserting the record into MS-Access Database.

oleDBDataAdapter.Update(yourXMLDataSet, tableName)

Hope this will solve your problem.