Importing data from many xml files which has same schema into a single excel sheet

**mayurpatil** · 03-28-2012, 12:08 PM

Hi,

I have around 2000 xml files , can anyone suggest me what to do if i have to compile the data from them and view as rows in single excel sheet .

I tried using the XML mapping method , but i am only able to map a single xml. and not able to extract the data from all , if i have to do this i have to select each xml and open , which will be very tedious .

Please if anyone has a solution to this .I am attaching the xml which has the schema info.

Thanks in advance .

Regards,

Mayur

**PingPing** · 03-28-2012, 04:21 PM

If you want to automate the processing of 2,000 XML files then I suggest you either:

a) load them into a database (eg. MS Access or SQL Server) and then export from there into Excel; or

b) process them into a single XML file and then use VBA (which has the "OpenXML" method) to open that single XML file as a workbook.

**mayurpatil** · 03-29-2012, 04:15 AM

Hi ,
But is there any option for importing many xml files at one point in access .

Thanks in advance .

**PingPing** · 03-29-2012, 05:16 AM

Originally Posted by mayurpatil

is there any option for importing many xml files at one point in access?

Not that I'm aware of.

Importing data from many xml files which has same schema into a single excel sheet

LinkBack

Thread Tools

Rate This Thread

Display

Importing data from many xml files which has same schema into a single excel sheet

Re: Importing data from many xml files which has same schema into a single excel sheet

Re: Importing data from many xml files which has same schema into a single excel sheet

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions