Importing multiple XML files to excel

[LaurenH12]

Hi

I'm having trouble importing multiple XML files to excel at once. Does anyone know if this is possible?

I have been able to import one file at a time (however, this is importing the one file ~15 times) but not multiple XML files at once. I have been using the following procedure: Data > From Other Sources, and then click From XML Data Import

I have roughly 12,000 XML files I need to import in one excel spreadsheet.

Cheers,
Lauren

 

[RedBeard]

Try the code provided here: http://answers.microsoft.com/en-us/...to-excel/644a3a6b-6b33-4ef1-9790-c5c0c33a592e