asked on

Programtically Importing XML into Access Database Tables

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?

Bob Learned

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.

DylanJones1

ASKER

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

Bob Learned

What are you trying to get from the config file?

DylanJones1

ASKER

A few paths, a databse name, a file filter. I need to read the config file

ASKER CERTIFIED SOLUTION

Bob Learned

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

DylanJones1

ASKER

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

Bob Learned

Did you try this?

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

DylanJones1

ASKER

Yes That does not work either