?
Solved

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

Posted on 2008-09-29
5
Medium Priority
?
445 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 750 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 750 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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
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: …
Suggested Courses

752 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