Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikconsultant
Creator III
Creator III

How install the EXCEL ODBC in the System DNS?

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?

2 Replies
martinpohl
Partner - Master
Partner - Master

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

martinpohl_0-1618397588839.png

Regards

qlikconsultant
Creator III
Creator III
Author

Yes I know I tried this:

1.PNG

 Put in the name:

2.PNG

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.