reading xml data into access

[AnnIsabelle]

Hi,
I'm in the process of making an online store. My database is in Access and I consult it with ASP. The data in my tables has to come from xml-files.
Is there a way to get this information in Access without using the built-in importfeature in Access? I have a problem with the datatype conversions (everything is text) and I need to include some extra fields.

 

[JontyMC]

Could write ASP to do it. Or how about import XML to Excel, then import Excel to Access?

Jon

"I don't regret this, but I both rue and lament it.

 

[AnnIsabelle]

Is there some sample-ASP code somewhere out there to start from? Any links or books or ...?

 

[JontyMC]

I googled for 'asp access tutorial'. This looks ok:

http://www.webwizguide.info/asp/tutorials/default.asp

Jon

"I don't regret this, but I both rue and lament it.

 

[JontyMC]

You need to know how to manipulate XML with ASP too:

http://www.w3schools.com/dom/default.asp

Jon

"I don't regret this, but I both rue and lament it.