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
regards, Joyce