adiemeer
asked on
Macro to import XML in Access 2013
Hello,
I use Access 2013, and do have the next question. At my filesystem I have an XML-file 'sample.xml' and a XSLT 'conversion.xslt'. I want to import this XML file in Access using the conversion.xslt. manually this works fine:
- select External data / XML file
- select the sample.xml
- OK
- select Transform
- select the conversion.xslt
- choose Structure and Data
- OK
=> table is created with the information I want.
How can I make a macro to do this process automatically?
Regards Arne
I use Access 2013, and do have the next question. At my filesystem I have an XML-file 'sample.xml' and a XSLT 'conversion.xslt'. I want to import this XML file in Access using the conversion.xslt. manually this works fine:
- select External data / XML file
- select the sample.xml
- OK
- select Transform
- select the conversion.xslt
- choose Structure and Data
- OK
=> table is created with the information I want.
How can I make a macro to do this process automatically?
Regards Arne
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER