topic Re: Error reading Excel File with odbc driver in QlikView

Error reading Excel File with odbc driver

Wed, 10 Feb 2016 13:02:11 GMT

Hi,

I have an excel files and I'm reading using sqltables query but in windows server 2008R2 that's not work.

My string connection look like this:

OLEDB CONNECT TO [Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="DSN=Excel Files;DBQ=$(vArchivo); DriverId=1046; MaxBufferSize=2048; PageTimeout=5";];

Can any help me?

Re: Error reading Excel File with odbc driver

oknotsen — Wed, 10 Feb 2016 13:26:24 GMT

To load from an XLS file, just use the Table Files option.

LOAD *

FROM
filename.xlsx
(ooxml, embedded labels, table is sheetname);

Re: Error reading Excel File with odbc driver

petter — Wed, 10 Feb 2016 14:01:18 GMT

It is most likely due to not having the Excel OLEDB/ODBC driver not installed on the Windows Server 2008 R2 computer. This ODBC-driver is not standard but it gets installed when you install Office and you can also download it.

Both where to find the drivers and the alternative to using the OLEDB/ODBC driver is mentioned in this thread:

Load Multiple Sheets...sheets are Dynamic

Re: Error reading Excel File with odbc driver

Thu, 11 Feb 2016 13:24:18 GMT

I have installed the driver but it doesn't work; see the connection i'm using:

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

But i'm getting the next error:

SQL##f - SqlState: IM002, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Re: Error reading Excel File with odbc driver

Fri, 12 Feb 2016 16:29:30 GMT

Hi,

I just solved the problem. the problem was not of office driver; the happend is that the connection string uses a ODBC named Excel Files and i didn't have this created on my server. It exists in my personal computer because when isntall the office it create this driver (I don't remenber i have create on my pc).

From i created it connected correctly.

Solution:

Go to ODBC administrator and in the User DSN tab, create new ODBC named Excel Files.