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

N

nigel legin

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
 
D

Dirk Goldgar

nigel legin said:
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.
 

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