PC Review Forums Newsgroups Microsoft DotNet Microsoft Dot NET Framework Forms Import XML into MS Access

Reply

Import XML into MS Access

 
Thread Tools Rate Thread
Old 09-02-2006, 07:55 AM   #1
Lev
Guest
 
Posts: n/a
Default Import XML into MS Access


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 With Quote
Old 10-02-2006, 09:39 AM   #2
Tim_Mac
Guest
 
Posts: n/a
Default Re: Import XML into MS Access

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 With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off