Solved

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

Posted on 2008-09-29
5
442 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 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

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

705 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