XML to MSAccess (OleDb)

  • Thread starter Thread starter Eric Robishaw
  • Start date Start date
E

Eric Robishaw

It's a breeze to take an MSAccess table to XML, but how to you do the
reverse?

Given an XML file created from a DataSet using the WriteXML method,
including the Schema, how would you then read that XML file into a dataset
and then write the dataset to an Access Database table?

Reading into a dataset is easy: DS.ReadXML(filename), BUT once I have the
dataset, what's the best way to get it back out to a database Table?

Thanks
Eric Robishaw
 
Sorry about that, I hit the wrong button. If you use the Diffgram option,
you'll have the row state of all of your fields...

Then you can use a commandbuilder or supply your own update logic,
deserialize the Dataset(Using ReadXML again) and fire
dataadapter.Update(yourDataSet)
 
Back
Top