Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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.