Problem importing XML in Excel 2k3

I

IronEddie

*sigh*

Let me stop pulling my hair out for a minute to type up this post.


Ok...here goes...

What I am trying to do is make a spreadsheet that contains quite a fe
XML feeds. The problem is I am finding no way of importing the 2n
feed.

Here is the link to the first feed, which I was able to import n
problem:
http://www.dicepoint.net/Feed/XMLFeed/6675/15/stats.xml

Now here comes the problem...the other information I am trying t
import contains individual #s (the <CharID></CharID> number from th
first feed). I.E...the first user's 2nd XML feed would be:
http://myplanetside.station.sony.com/character.jsp?worldId=15&charId=35101
where the 351017 is his <CharID>.

So basically I want Excel to pull in the first XML feed on the fron
tab, and then on 3 tabs after that use the <CharID> field to pull i
seperate XML feeds for each person listed in the first feed and the
input the appropriate (in this case, the Certification fields) in th
spreadsheet...

Any help is much appreciated...even if it is just to say that it'
impossible to do.

Thanks alot
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

import form excel 3
Excel Import XML into Excel 0
Keeping Format Importing From Excel 8
Excel 2003, Convert EXISTING Worksheet Data to XML? 4
Problems Importing Govt. XML Files 1
import xml not a problem, setting key for subtables is 1
Problem importing into Access 2000 from Excel 2003 2
HTML/XML format for Excel 2000. Multiple sheets in single HTML file 0

Top