Solved

Using a Windows form in VS 2008 insert xml into MS Access table

Posted on 2008-09-29
5
426 Views
Last Modified: 2013-12-17
I have an xml stream that I would like to insert into an Access database.  The xml structure is similar to:

<person>
   <uniqueID></uniqueID>
   <name></name>
   <password></password>
</person>
<person>
....
</person>
0
Comment
Question by:PIER117
  • 3
  • 2
5 Comments
 
LVL 11

Accepted Solution

by:
William earned 250 total points
ID: 22606849
Can you create a dataset of this xml and then use it to populate your table?
0
 
LVL 1

Author Comment

by:PIER117
ID: 22607769
It can probably be done because I can write an xml file.  How would I populate a dataset and write to a table?

0
 
LVL 11

Assisted Solution

by:William
William earned 250 total points
ID: 22607814
Drag a dataset onto your work area (form or component) and set it up to match your xml file or I think you can point it to one as well...

After this I believe you can also set it up to point to the database you want it to point too.
0
 
LVL 1

Author Comment

by:PIER117
ID: 22620232
0
 
LVL 1

Author Closing Comment

by:PIER117
ID: 31501333
I was able to find the solution elsewhere, but the comment pointed me in the right direction.
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

This article describes relatively difficult and non-obvious issues that are likely to arise when creating COM class in Visual Studio and deploying it by professional MSI-authoring tools. It is assumed that the reader is already familiar with the cla…
In my previous two articles we discussed Binary Serialization (http://www.experts-exchange.com/A_4362.html) and XML Serialization (http://www.experts-exchange.com/A_4425.html). In this article we will try to know more about SOAP (Simple Object Acces…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now