Import multiple XML tables into MS Access?

Question

I have several XML files with homogenous data. I would like to import them all into Access at once (I have tried individually, and it is too easy to lose track of which file I last imported). Preferably, it would be nice to import them all into one table, but if not, I can simply do a Union after import.

Answer 1

How many files? If you're familiar with a programming language you could easily concatenate all the files into a single xml file.

Answer 2

Import or link to create a table
You can create a table by importing or linking to information stored elsewhere. For instance, you can import or link to information in an Excel worksheet, SharePoint list, an XML file, another Access database, a Microsoft Office Outlook 2007 folder, and a number of other sources. When you import the information, you create a copy of the information in a new table in the current database. Conversely, when you link to the information, you create a linked table in the current database that represents a live link to the existing information that is stored elsewhere. Thus, when you change data in the linked table, you also change it in the original source too (with some exceptions — see the note below). When information is changed in the original source by using another program, that change is visible in the linked table.


Note In some cases, you cannot make changes to your data source through a linked table, most notably when the data source is an Excel worksheet.Create a new table by importing or linking to external data
Click the Microsoft Office Button , and then click Open.
In the Open dialog box, select and open the database.
On the External Data tab, in the Import group, click one of the available data sources.


Follow the instructions in the dialog boxes.
Access creates the new table and displays it in the Navigation Pane.


Good luck hope this helps!!!