B bhasoriya Member Dec 19, 2012 #1 I have thousands of .xml files. i want to import all in excel rowwise with file name. i tried to import but i m not able to add multiple files.. Can anybody help me please..
I have thousands of .xml files. i want to import all in excel rowwise with file name. i tried to import but i m not able to add multiple files.. Can anybody help me please..
I imgonna New Member Dec 19, 2012 #2 Hi Found this on the interweb.... "Actually you can import multiple xml files into Excel (at least I could in 2003). If the files have identical structure create a map from any of them. Then just import the files you want through Data - XML - Import. The files should be located in one folder just select as many as you like." But never tried it..... G
Hi Found this on the interweb.... "Actually you can import multiple xml files into Excel (at least I could in 2003). If the files have identical structure create a map from any of them. Then just import the files you want through Data - XML - Import. The files should be located in one folder just select as many as you like." But never tried it..... G
B bhasoriya Member Dec 19, 2012 #3 Hello Imgonna, I have tried too... but there was an error while importing all files. And would also want file's name in it.. Might be i am not following step by step.. Could you please guide me.. Thanks dear..
Hello Imgonna, I have tried too... but there was an error while importing all files. And would also want file's name in it.. Might be i am not following step by step.. Could you please guide me.. Thanks dear..
