Anyone have any ideas on how you'd go about converting a .xml file into an excel spreadsheet, or into an access database or something ?
Printable View
Anyone have any ideas on how you'd go about converting a .xml file into an excel spreadsheet, or into an access database or something ?
I would first decide what are to be made into rows and what is to be made into columns. Then it should be fairly simple to load the XML into a MSXML object, roll throug the elements, extracting the appropriate data and puttining it into the destination -- an Excel app, or Access (I would use ADO for this).
I'm guess ing it would be easier to import it into Access (or any database) than Excel.
Two new methods have been added to the
Microsoft Access 10.0 Object Library for handling XML:
ImportXML and ExportXML.
A quick search should sort you out
Cheers guys I'll give it a go :)