[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Programtically Importing  XML into Access Database Tables

Posted on 2008-06-23
8
Medium Priority
?
2,232 Views
Last Modified: 2013-11-29
MS Access 2003 has a great Imprt utility for XML.   I would like to accomplish the same task programtically using C#,   I have search the Google over and never found a true solution.  Does anyone here have specific approach.    

I can easily read the XML into a dataset  but how to get that in MS Access?  
0
Comment
Question by:DylanJones1
  • 4
  • 4
8 Comments
 
LVL 96

Expert Comment

by:Bob Learned
ID: 21849148
You could read the XML into a DataSet, and then import the rows from the XML file into another table that is bound to the Access database, and then update the database.
0
 

Author Comment

by:DylanJones1
ID: 21849329
Yes that is the path I am heading down  I was, of course, hoping for something that would leverage the work that the import feature has already accomplished.     Can you tell me  what I need to do to get my window service to look at its own config file rather than the machine.config?  

This
onfiguration config = ConfigurationManager.OpenExeConfiguration(System.AppDomain.CurrentDomain.SetupInformation.ApplicationBase);

and this
//for testing my service
Configuration config = ConfigurationManager.OpenExeConfiguration(System.Windows.Forms.Application.ExecutablePath)

both bomb out

0
 
LVL 96

Expert Comment

by:Bob Learned
ID: 21849382
What are you trying to get from the config file?
0
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 

Author Comment

by:DylanJones1
ID: 21849458
A few paths, a databse name,  a file filter.   I need to read the config file
0
 
LVL 96

Accepted Solution

by:
Bob Learned earned 1500 total points
ID: 21849565
If you get them from the appSettings section, you should be able to use ConfigurationManager.AppSettings.
0
 

Author Comment

by:DylanJones1
ID: 21849674
Here is my code -  this is a windows service that I am debugging via a fom

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <appSettings>
    <add key="DatabaseUpdaterRemotePath" value="Y:\IPB\Dch" />
    <add key="DatabaseUpdaterLocalPath" value="C:\IPXML\Dch" />
    <add key="DatabaseUpdaterFilter" value="*.XML*" />
    <add key="DatabaseUpdaterIncludeSubs" value="true" />
    <add key="DatabaseName" value="Disconnected.MDB"/>
  </appSettings>
</configuration>

onfiguration config = ConfigurationManager.OpenExeConfiguration(System.AppDomain.CurrentDomain.SetupInformation.ApplicationBase);

and this
//for testing my service
Configuration config = ConfigurationManager.OpenExeConfiguration(System.Windows.Forms.Application.ExecutablePath)

Then
RemotePath = config.AppSettings["DatabaseUpdaterRemotePath"].ToString();

this blows up and the appsettings are empty - it is automatically pulling from machine.config


0
 
LVL 96

Expert Comment

by:Bob Learned
ID: 21849817
Did you try this?

string remotePath = ConfigurationManager.AppSettings["DatabaseUpdaterRemotePath"];
0
 

Author Comment

by:DylanJones1
ID: 21850074
Yes That does not work either
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
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: …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

834 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