topic Re: Issue with deploying code reading multitab excel in QlikView

Issue with deploying code reading multitab excel

amars — Mon, 26 Jan 2026 18:19:17 GMT

Hi all,

I have few excel files with multiple tabs. The tab names are not consistent and can change over time but the format of the tabs is same.

Thus when reading multiple tabs I am using the below code

For Each vFile in FileList('$(vFolder_FileFormat)')

     ODBC CONNECT32 To [Excel Files;DBQ=$(vFile)];

     Sheets:

     SQLTABLES;

     DISCONNECT;

     For i = 0 To NoOfRows('Sheets')-1

        Let zSheet = Peek('TABLE_NAME', i, 'Sheets');

Data:

LOAD

*

FROM [$(vFile)]

(biff, embedded labels, table is $(zSheet));

     Next



Drop Table Sheets;

Next

Now since our Qlikview server doesn't have a Excel installed the line "ODBC CONNECT32 To [Excel Files;DBQ=$(vFile)];" is giving me error.

Is there any way to just install Excel drivers and make the code work without installing microsoft office?

Kindly suggest. Many Thanks in advance.

Regards

Amar

Re: Issue with deploying code reading multitab excel

settu_periasamy — Thu, 04 Feb 2016 05:27:42 GMT

Hi,

Have you tried Single Excel file using ODBC Connection ?

Re: Issue with deploying code reading multitab excel

tamilarasu — Thu, 04 Feb 2016 05:36:55 GMT

Hi Amars,

You can download and install ODBC drivers from Microsoft site. You don't need to install Microsoft office.

Re: Issue with deploying code reading multitab excel

amars — Thu, 04 Feb 2016 05:39:17 GMT

Hi Settu,

My issue is since the server doesn't have microsoft office, the options to connect to ODBC Excel drivers are not installed. Is there a way to just install Excel ODBC drivers without installing microsoft Office.

Regards

Amar

Re: Issue with deploying code reading multitab excel

amars — Thu, 04 Feb 2016 05:40:01 GMT

Can you suggest any link to install the ODBC drivers? Many Thanks...

Re: Issue with deploying code reading multitab excel

tamilarasu — Thu, 04 Feb 2016 05:49:34 GMT

Check the below link,

Download Microsoft Access Database Engine 2010 Redistributable from Official Microsoft Download Center

Re: Issue with deploying code reading multitab excel

jagan — Thu, 04 Feb 2016 05:52:47 GMT

Hi,

You can download ODBC driver from Microsoft website.

check this link for dynamically loading all excel files and sheets

Load all Excel files and all sheets in a folder

Regards,

Jagan.

Re: Issue with deploying code reading multitab excel

amars — Thu, 04 Feb 2016 06:22:16 GMT

Hi all,

Installed the drivers from the below URL

https://www.microsoft.com/en-us/download/confirmation.aspx?id=13255‌

in User DSN clicked on Add and selected the Microsoft Excel Driver. Named it as "Excel Files" and it worked.

Thanks all.

Re: Issue with deploying code reading multitab excel

amars — Thu, 04 Feb 2016 06:24:48 GMT

Also make sure to user the correct version of installer (32 bit or 64 bit). Accordingly user Connect32 or Connect64 or simply use Connect. Thanks again

Re: Issue with deploying code reading multitab excel

Thu, 11 Feb 2016 13:15:51 GMT

Hi peoples,

I have installed the driver but but i'm getting the next error however.

ErrorSource: Microsoft OLE DB Provider for ODBC Drivers, ErrorMsg: [Microsoft][ODBC Driver Manager] Invalid argument value

OLEDB CONNECT TO [Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="DSN=Excel Files;DBQ=\\diqlvsrv\RawData\Files\Cobros\01022016.xls; DriverId=1046; MaxBufferSize=2048; PageTimeout=5";]

I have tryied using the next code:

ODBC CONNECT32 To [Excel Files;DriverId=1046;DBQ=$(vArchivo)];

and the error appear is: the default driver was not specified.

Re: Issue with deploying code reading multitab excel

tamilarasu — Thu, 11 Feb 2016 16:04:46 GMT

Seems you haven't create a ODBC connection. Check the below link for details.

Connection error to the server

Re: Issue with deploying code reading multitab excel

amars — Fri, 12 Feb 2016 05:38:55 GMT

Hi Julisy,

Try

ODBC CONNECT To [Excel Files;DBQ=$(vArchivo)];

Also make sure the variable $(vArchivo) contains valid Excel File Name.

Also you can test by creating an ODBC connection in Qlikview for a sample file by going to Edit Script

Data Tab -> ODBC -> Click Connect.

On the Connect To Data Source Window -> Select Show User DSNs

The "Excel Files" Data should appear in the windows -> Select "Excel Files" and Click Ok.

Then Select the Sample Excel file for which you wish to set up the connection. Click Ok.

If the "Excel Files" Data source is not appearing in the window when the "Show User DSNs" is selected, then go to ODBC -> User DSNs -> Click Add -> Select Microsoft Excel Drivers(*.xls, .....) -> Click Finish.

In the Next window -> put Data Source Name as "Excel Files".

After the above step it should work. Thanks....

Re: Issue with deploying code reading multitab excel

Fri, 12 Feb 2016 14:41:36 GMT

Hi, people.

Already i solved this problem. my problem was not of driver. the problem is the connection string use the DSN Excel Files and i didn't have created in my odbc list of drivers.

From i created in the list odbc drivers; it work correctly.

See images here