Installed the drivers from the below URL
in User DSN clicked on Add and selected the Microsoft Excel Driver. Named it as "Excel Files" and it worked.
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.
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....