Import XML into Access/Excel

[LeanneGodney]

Hi there,

I need to know how to import .xml files into excel, access, sql, anything - to enable analysis of this data.

Any ideas anyone?

Thanks,
Leanne

 

[teju79]

I'm interessed too!

 

[flumpy]

With Excel there are a few ways to do this:


1) transform using XSLT the xml into a comma separated value file
2) transform using XSLT the xml into a tab separated value file
3) transform using XSLT the xml into Excel's XML format (you can see this if you save an excel document as XML)
4) read in the xml with a parser and use an Excel object and write the data into it directly


Of these ways, 1 and 2 are easiest. 2 is the best solution, since if you save the TSV file as a .XLS excel will read this without promting users to import the values.


With Access or SQLServer you'd have to write a proprietory program to do it, much as in 4 above, except using SQL statements to insert data correctly.

Hope this helps.

Matt

 

[MikalAU]

I have found that using crystal reports to read the data, then I can either use the report designer to do what I require or export it to whatever format I require.

Not much I know but I have found this easy (if you have crystal report 8.5 or above)