Excel 2000

J

Jay Singh

Does Excel 2000 support Importing XML Data? If yes, how do I activate the
function the function?
 
P

Pete_UK

No, I think this was introduced in Excel 2003.

What I did when receiving some files in this format was to rename the
extension to .hml and then open within Internet Explorer by double-
clicking. From there I could use File | Save As to save the file
as .TXT, which I could then put into Notepad to tidy it up further.
Saving the file as .txt again enabled me to import it into Excel in
the format I required. Is .XML meant to be an improvement?

Hope this helps.

Pete
 

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

Top