I have an XML download I want to load to Access. I can do this for most
of the sub-nodes of the xml document. However, one node has about 400
fields. I would like to break it up and store in two Access tables.

Anyone done this via VBA or a utility? If VBA, care to share the code?

Bob

On 9/7/10 5:08 PM, Bob Alston wrote:
IMHO, it's probably easier to use a XSLT to transform the incoming XML
into a structure that's compatible with Access. You can have it
transform into structure that Access will be then able to import into
several tables to maintain normalization.

Note that Access already has TransformXML method built-in so you're just
a XSLT away.

On 9/7/2010 8:21 PM, Banana wrote:
will need?

Bob

On 9/7/10 6:45 PM, Bob Alston wrote:
To learn about the syntax for XSLT, I primarily used w3schools. You may
need to read up on XML as well XPath to round out the study.

http://www.w3schools.com/xsl/

For writing the XSLT, I've found that Visual Studio has pretty decent
editor, providing intelllisense for the XML keywords as well any custom
schemas you may. Unfortunately, I never found out whether this is
available in Express Edition (I'd be surprised if it wasn't, though).
You don't have to create a Visual Studio project - just choose "New
File", and choose XSLT then you can start writing, and it also provides
a debugger so you can see what your XSLT will output.

That's basically what I did - there's certainly several other XML
editors and tutorials out there.

HTH.