PC Review
Forums
Newsgroups
Microsoft DotNet
Microsoft Dot NET Framework Forms
Import XML into MS Access
Forums
Newsgroups
Microsoft DotNet
Microsoft Dot NET Framework Forms
Import XML into MS Access
![]() |
Import XML into MS Access |
|
|
Thread Tools | Rate Thread |
|
|
#1 |
|
Guest
Posts: n/a
|
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 |
|
|
|
#2 |
|
Guest
Posts: n/a
|
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 |
|
![]() |
|
| Thread Tools | |
| Rate This Thread | |
|
|

Main Page 

