I am trying to import an xml file into MS Access
When I manually import the file using Structure and Data it imports fine, but creates several tables within MS Access: Cell, DocProperties, ExcelWorkbook,Pane,Style,T
able, and Worksheet Options. I find all of my data in the table called Cell and with a column called Data.
When I try to import the file into MS Access using the below code it only works if the 7 tables above still exist. Am I always forced to load this file into a table called Cell ? Why do I need to maintain all of these 7 tables in order to do the import from the XML file into MS Access ?
Is there a better way of importing an XML file int MS Access than I have provided ?
Const acAppendData = 2
Set objAccess = CreateObject("Access.Application")
objAccess.ImportXML "c:\scripts\test.xml", acAppendData