Data Source Name not found and no default driver specified.

My operating system is Windows 10 Pro 64-bit.
I am using Microsoft 365 32-bit.
I am trying to use ODBC to connect to an xlsx file from Exportizer Enterprise 64-bit
When I use the following connect string:
Provider=MSDASQL;Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=D:\Convert\From\Counties.xlsx;
I get:
Database connection error
[Microsoft] [ODBC Driver Manager] Data source name not found and no default driver specified

1 answer

If your Microsoft Office is 32-bit, then you should use Exportizer Enterprise 32-bit instead of 64-bit.