topic Re: How install the EXCEL ODBC in the System DNS? in QlikView

How install the EXCEL ODBC in the System DNS?

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

I try to connect an Excel file via ODBC

SET DateiV=D:\Data\file1.xlsx;

ODBC CONNECT32 TO [Excel Files;DBQ=$(DateiV)];

But I get an error message:

ODBC error

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

ODBC CONNECT32 TO ***

The driver is only installed in the User DSN.

What do I have to do, to see it in the System DSN?

Re: How install the EXCEL ODBC in the System DNS?

martinpohl — Wed, 14 Apr 2021 10:53:23 GMT

so you have to create the odbc connection in the odbc 32 administration console

Regards

Re: How install the EXCEL ODBC in the System DNS?

qlikconsultant — Wed, 14 Apr 2021 11:26:21 GMT

Yes I know I tried this:

Put in the name:

And then I the same error:

ODBC error

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

ODBC CONNECT32 TO ***

So something what i'm doing is wrong. But not sure what.