how do i convert xml files to ms access or ms excel

[Guest]

i can receive xml files via the net but need to convert them to ms access or
ms excel format.
Can i have input on how to resolve the matter?
Thanks
Nigel

 

[Dirk Goldgar]

i can receive xml files via the net but need to convert them to ms
access or ms excel format.
Can i have input on how to resolve the matter?
Thanks
Nigel

Access 2000 and later can import XML files. I believe XML support is
better in the later versions. The process is to click File -> Get
External Data -> Import..., then in the Import dialog choose Files of
type: XML Documents (*.xml, *.xsl). Choose the file to import and click
the Import button. If you click the Options>> button on the next
dialog, you can choose to import the structure only, structure and data
(the default), or to append data to an existing table.