[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Programtically Importing  XML into Access Database Tables

Posted on 2008-06-23
8
Medium Priority
?
2,224 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
[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
  • 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
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 

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

Tech or Treat! - Giveaway

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

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

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

650 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