View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mungkol Mungkol is offline
external usenet poster
 
Posts: 2
Default Import Multiple XML Files into Excel

Dear all,

I would like to find some statistic of data from multiple XML files
using Excel 2007. I want to import all the files in a folder and sub-
folder into one EXCEL spreadsheet. Each XML file has the identical
structure, but different data. I want to define the XML map in Excel,
and import data for each file, with each file's data being on a new
row.

By the way, it seems that excel does not allow to import many files at
once. :(

Any hints?

Thanks in advance.

Mungkol