Import XML Data

  • Thread starter Thread starter BigGeorge
  • Start date Start date
B

BigGeorge

I have some data in XML format that I need to read into a
database or spreadsheet format. Any ideas?
 
Excel 2002 is the only released version of Excel that knows what to do with
an XML file. Earlier versions just see it as a text file to be parsed. If
you have Excel 2002 you can just do a File, Open on the XML file. For more
info you might look at these articles:

http://msdn.microsoft.com/library/en-us/dnexcl2k2/html/odc_xlflatnr.asp

http://support.microsoft.com/default.aspx?scid=kb;[LN];288215


Going outside of the abilities built into Excel you can reference the MSXML
library and use the Document Object Model (DOM) to bring data into Excel
from an XML file by macro.
 
Back
Top