Import XML into MS Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lev - 09 Feb 2006 07:55 GMT

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

Reply to this Message

Tim_Mac - 10 Feb 2006 09:39 GMT

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

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...