How to load the excel data by using ODBC connection?

[Anonymous]

Hi all,

  I am having one excel "data.xlsx" file. In that am having no of worksheets which contains same field name(column name) in all worksheet. I dont want to write a script for each worksheets. May be in future if they add some more worksheets, it should work if we reload.  For that using odbc connection am trying to load the excel file. I want to know which driver i have to use for loading excel file.  Am facing issue in connection string .Anyone please suggest me how to solve this issue?

Regards,

NIsha loganathan.

[tresesco]

You might not need connection for that. A simple loop could get you there. Check this post: http://community.qlik.com/message/306398#306398

[Anonymous]

Hi Tresco,

Thanks for your reply. Am having sheet name as'Housing Allowance', Transport Allowance', 'Annual Bonus' likewise am having so many sheets which all having different worksheet name. In that case am trying to get lists of all sheets in an excel by using odbc connection and calling SQLTables function.

Regards,

Nisha loganathan.

[tresesco]

In that case, yes, a connection (ODBC/OLEDB) would be required. What is the exact issue you are facing?

[Anonymous]

Hi,

yeah. Can you please tell me which provider i have to use to connect with excel files??

Regards,

NIsha loganathan

[maxgro]

a small example (qvw and excel in the attachment)

[tresesco · Accepted solution]

ODBC. Check: http://community.qlik.com/message/626457#626457

[avinashelite]

Hi Nisha,

Please check this below document for the complete soultion.

Loading Multiple Excel Sheets Dynamically along with file name and sheet name

[Anonymous]

Hi Tresco,

Thanks for your reply. I have done the connection successfully.

Regards,

Nisha loganathan.

[Anonymous]

Hi all,

Thanks . I have implemented the same as what you have suggested. But while reloading am getting some error.

Error: File extdata.cpp, Line 2792. Hereby i have attached the image.

Can anyone please explain me?

Regards,

NIsha loganathan.