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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Import & Link section grayed out MS Access 2010 1
Finding the weighted average of text that have been given values 1
How to export table from outlook into ms access table? 0
Liquid Technologies Release Liquid XML Studio 2014 1
XML DTDs Versus XML Schema 0
Excel Import XML into Excel 0
Importing Text Files Into Access 1
Access Import MS Outlook messages into MS Access - The Email Body Loses Formatting 0

Back
Top