Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
nishaloganathan
Contributor II

How to load the excel data by using ODBC connection?

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.

1 Solution

Accepted Solutions
MVP
MVP

Re: How to load the excel data by using ODBC connection?

10 Replies
MVP
MVP

Re: How to load the excel data by using ODBC connection?

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

nishaloganathan
Contributor II

Re: How to load the excel data by using ODBC connection?

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.

MVP
MVP

Re: How to load the excel data by using ODBC connection?

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

nishaloganathan
Contributor II

Re: How to load the excel data by using ODBC connection?

Hi,

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

Regards,

NIsha loganathan

MVP
MVP

Re: How to load the excel data by using ODBC connection?

a small example (qvw and excel in the attachment)

MVP
MVP

Re: How to load the excel data by using ODBC connection?

Re: How to load the excel data by using ODBC connection?

Hi Nisha,

Please check this below document for the complete soultion.

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

nishaloganathan
Contributor II

Re: How to load the excel data by using ODBC connection?

Hi Tresco,

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

Regards,

Nisha loganathan.

nishaloganathan
Contributor II

Re: How to load the excel data by using ODBC connection?

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.

error.png

Can anyone please explain me?

Regards,

NIsha loganathan.

Community Browser