Importing multiple XML files in one go

Hi there

Ive just started using Excel 2016 and I am much impressed with it so far but I'm in need of some help and advice.

I have an epos system that allows me to export all of our shop sales using XML format. I want to be able to import all our sales month by month and use a pivot table to show the data to see any trends etc.

What I have done for the first year of sales is to export the sales month by month from the till to an XML file then import each file one at a time into a different workbook then copy+paste the data to a workbook that will hold all the years data.

I have found that if I try to add another XML file to the first one it overwrites the first import, that is why I use a new workbook for each import.

What I want to be able to do is append each import of data to the previous one, or import all 12 files at once. Is there a way to do this?

Thank you

Maybe try: New Query - From Folder (where XML files are)

Thank you.

I'm unable to select more than one file.

Thanks sandy666. I didn't see the folder option first time round. All imported now.

You are welcome

so...
If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.
If you did it already - ignore it.
Thank you.