Importing XML into Excel 2003 from a URL

  • Thread starter Thread starter BigAndy
  • Start date Start date
B

BigAndy

I wondered if you could help me, I want to create a spreadsheet that
is updated vie a link to a standard web XML file. All the discussions
I've seen are regarding importing from a SQL server or a static file
but how would you import from (for example) www.example.com/file.xml
or file.aspx??
 
SQL files have standard format while XML files very a lot. I would start by
saving the XML file on your PC and then look at the text with Notepad. You
can write a script that reads the text file and then extracts the data you
want. Later you can automat fully by geting the XML file from the internet.

XML files are hypertext ascii files.they would look like this

<text>One line of Text<end text>

<text> and <end Text> are tags. In a XML file there will be header tags,
fiormat tags, and data tags. to extract the datq you need you'll have to
search the tags and only get the tags you need to complete your task.

the best way tosee how complicated the job would be is to look a the file
with NotePad or we you are looking the page with the internet explorer View
Source in the Page Menu.
 
Back
Top