Importing XML Files To Excel

Can anyone recommend something that tells how to import XML files to Excel (or Access) that starts at the "for dummies" level? I'm pretty conversent with both Excel and Access but don't know much about XML files, or "Schema" or any of that stuff.

Thanks.
Buck_BeasomDatabase DesignerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Chris Raisin(Retired Analyst/Programmer)Commented:
XML is basically text that has data seperated by tokens.
If we know the names of the tokens (as showing in the XML) we can ascertain the valu by reading in the XML file and searching for the required Token.

There is code somewhere in my library that does this, and I will work on this later tonight after I return from my duties at church this afternoon.

If you can hold on for a few hours, I think I might have a solutoion for you.

Cheers

Chris (craisin) - Melbourne, Australia
0
Buck_BeasomDatabase DesignerAuthor Commented:
Hey craisin. Any luck with that information?
0
Chris Raisin(Retired Analyst/Programmer)Commented:
Thanks for getting back to me....I forgot all about it! Sorry!

Can you supply some dummy XML code that looks like your XML? I definately have some code and I can easily whip it up foryou and supply a step by step way of processing the data.

BTW, will the XLM you use be changeing in structure often?

Look inside your XML using a text editor and your will see what are called "Tags". They are text items starting with "<" (Open arrow-head) followed by one or more words and then finishing with ">" (Closed arrow-head).
Some Tags take on thsis sort of format:   "<TITLE>This is a title</TITLE>" where the "<TITLE> is the opening Tag  and "</TITLE> is the closing Tag for the data item (also known as "element") called TITLE. The value contained in the element is contained between the opening Tag and the closing Tag.

The code locates the tags and processes them, finding the opening Tag and Closing Tag, and ascertaing the values therein. It can become quite involved, because there are often "Tags within Tags" (so to speak).

An example of a "Purchase order Item might be like the following,with multiple items in the element "Item" as well as more than one element contained in the element "ShipTo". (I dragged this out of some sample code
I had hanging around). LOL

<po:purchaseOrder orderDate="2001-01-01" xmlns:po="http://www.ibm.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.ibm.com PurchaseOrder.xsd">
  <shipTo country="US">
    <name>Alice Smith</name>
    <street>125 Maple Street</street>
    <city>Mill Valley</city>
    <state>CA</state>
    <zip>90952</zip>
  </shipTo>
  <billTo country="US">
    <name>Robert Smith</name>
    <street>8 Oak Avenue</street>
    <city>Old Town</city>
    <state>PA</state>
    <zip>95819</zip>
  </billTo>
  <po:comment>Hurry, my lawn is going wild!</po:comment>
  <items>
    <item partNum="872-AA">
      <productName>Lawnmower</productName>
      <quantity>1</quantity>
      <USPrice>148.95</USPrice>
      <po:comment>Confirm this is electric</po:comment>
    </item>
    <item partNum="926-AA">
      <productName>Baby Monitor</productName>
      <quantity>1</quantity>
      <USPrice>39.98</USPrice>
      <shipDate>2001-07-21</shipDate>
    </item>
  </items>
</po:purchaseOrder>

Open in new window


It is 3.50am and I had better get to bed, but I will get back to you tomorrow....promise! (Sorry)  (blush)   :-)
Just let meknow what your HTML looks like (avoid email addresses or confidential information though).

Cheers
Chris (Melbourne, Australia)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Office Productivity

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.