how to update database from *.xml

[meoabc]

Hello,

I was stucked when try to insert data from a *.XML file to SQL database.This *.XML created when I select data from a table in Access Database. Then I want to use this XML to update again to SQL database. I can use DataSet to read this XML file, but dont know how to insert its values to SQL database. Could you show me somethings

Thanks in advance

 

[Bucky]

You access the data stored in the DataSet by using its
Tables property, which contains a collection of DataTable objects.
The DataTables, in turn, contains Rows and Columns, which are
also both collections.

All three of these collections can be accesed by an index (a number)
or a name (a string).

As for the SQL part... unless theres a special SQL method to
inserting data from an XML file, you will have to do that part
manually.

HTH