how to fetch all the exel sheet while reload

[rohit214]

hI all,

In my data souce whhich is bunch of excel files, i want to reload all the exccel file in sigle shot i.e. while reload i want to fetch all the excel sheet in qv

and the format of my excel file islike a.xlsx and in that file sheet name is also a,

same for b.xlxs and sheet name is b ans so on...

please help me to short out this problem.

Thanks

Rohit

[rohit214]

any one...  please help

[#3]

Check out this link. Very nice post on Excel.

http://qlikviewnotes.blogspot.sg/2008/09/loading-multiple-excel-sheets.html

[rohit214]

hi

i am not able to connect or make oledb connection because i don't have drivers.

thanks

rohit

[#5]

I Suggest you install the drivers from MSDN.

[kaushiknsolanki]

Hi,

     Have a look at the example attached on your earlier post.

     http://community.qlik.com/thread/77235?tstart=0

Regards,

Kaushik Solanki

[rohit214]

Hi,

is there any other way?

thaks

rohit

[rohit214]

please help me...any idea

[#9]

If you can't do above steps. then you need to use Excel Splitter tool which will split the sheets into individual excel files then you can use the loop to teaverse each excel file and load the data.