When importing XML files, not the entire structure is imported

Joyce

Registered User.
Local time
Yesterday, 19:46
Joined
May 12, 2010
Messages
19
I'm trying to import an xml file with invoices for our company. I've tried importing it without a table present and i tried with a prefix table with all the columns i want to import. In both situations Access doesn't import all the columns. When looking at the structure I can see that Access doesn't rekognize all the attributes. When importing the XML into Excel and then importing the Excel file into Access I have no problems and all the data is imported. Has anyone heard of this problem and can help me with the solution?

regards, Joyce
 

Users who are viewing this thread

Back
Top Bottom