Reading XML Data?

  • Thread starter Thread starter Linn Kubler
  • Start date Start date
L

Linn Kubler

Hi,

Kind of new at Access and I'm using Access 2002 and I'd like to read in an
XML file but I'm not sure how best to accomplish this.

Do I need to create the table first or is there a way Access will import and
make the table on the fly?

Over time I will be reading in multiple files like this should I create a
VBA macro or is there a wizzard I should use?

Any suggestions are appreciated.

Thanks in advance,
Linn
 
You can Import XML like any other file type and either add to an exsting
table or create one on the fly.
A2003 works better with XML.
 
Here's what I've found out since my original post. The XML document I'm
working with is a mixed attribute and element-centric file. From what I can
tell from the MS KB Access only supports importing element-centric XML.

I'm now trying to figure out how to write an XSL Transform to handle the
mixed mode.

If you have any suggestions or examples on how to do that I'd appreciate it.

Thanks,
Linn
 
Back
Top