Import XML into MS Access

  • Thread starter Thread starter Lev
  • Start date Start date
L

Lev

Hello all,

I develop a WinForms application with capability to import data from a large
XML file into the MS Access database.
Which way is a best way to perform it?

Thanks in advance,
Lev
 
hi lev,
i would use DataSet.ReadXml to get the data into ADO.Net.
then you could either try and use a DataAdapter, or perhaps simpler
would be to just iterate through the Dataset rows and execute an sql
command for each one. if you know the structure of the table before
hand, you can design the sql query in VS so you have the parameters all
ready to go.

tim
 
Back
Top