Jun 04 2022 08:54 AM
Jun 04 2022 08:54 AM
I'm trying to import several XML files into Microsoft access. When I use the XML import wizard however, access imports the XML file creating multiple tables, rather than a single table where each record in the table is from one of the XML files. Is there a way to import an XML file into a single table, rather than it creating multiple tables?
Jun 05 2022 05:13 AM
Jun 05 2022 05:42 AM
Jun 05 2022 06:03 AM - edited Jun 05 2022 06:04 AM
@JBLT83 We are getting closer, thanks.
Each XML file is supposed to import data into a table. There are different XML files, so there is one table for each XML file, correct? Or should all of the XML files import into the same Access table? That may not be relevant to the specific problem, but it's still not quite clear how it all needs to work.
The problem point is that the import process creates one table for each field in the XML file. How are these XML files created? Have you independently validated that they are, in fact, well-formed XML? Is it possible that the problem is not in the import, but in the way the XML is structured? Can you open the XML files in an application like NotePad++ and verify that it is good?
Is it possible to share a sample of one of these XML files?
Jun 05 2022 09:15 AM - edited Jun 05 2022 09:15 AM
What I was expecting was each file I import, is imported as a new record into an existing table that is created after importing the first xml file. I’m not familiar enough with xml file structure so it could be that the files aren’t structured in a xml format to be imported into a single table but as multiple tables, if there is such an xml structure for that. I thought the way xml structure worked was each defined field name was equivalent to a database column and the value contained within the xml name tags would be inserted as a table row. But that’s not the case I guess with how the files I was sent are importing into access. Attached is a snippet of the beginning of one of the xml files.
Jun 05 2022 01:00 PM
Jun 05 2022 10:56 PM