Install Microsoft Excel Driver (*.xls *.xlsx *.xlsm *.xlsb)
Hi OS: Windows 7 64bit; Office 2007; Used Excel file type: *.xls (must be compatible with Office2000 and with Office2007) I have an application where some data are entered into Excel worksheet (p.e. On sheet InputSheet, a nondynamic name p.e. MyData=InputSheet!$A$1:$X$10000 is defined. On another sheet, p.e. ReportSheet, I use an ODBC query with named range MyData as source to display certain data from InputSheet. I have designed applications like this before, when I had Windows XP 32bit as OS and Office2000, and they worked perfectly. So on ReportSheet, I select from menu Data>From Other Sources>From Microsoft Query>Excel Files*., and create a query.
Install Microsoft Excel Driver (*.xls *.xlsx *.xlsm *.xlsb)
It works a treat, so long as the Excel session lasts. After I close the Excel, and then open my Excel app anew, the error message is displayed whenever I try to refresh the query: ODBC Excel Driver Login Failed Unrecognized database format 'Mypath Myfile.xls' When I open ODBC Data Source Administrator, then on User DSN tab a data source is displayed: Excel Files, Microsoft Excel Driver (*.xls,*.xlsx, *.xlsm,*.xlsb) When I try to configure it, at first an error message is displayed: The Setup routines for Microsoft Excel Driver (*.xls,*.xlsx, *.xlsm,*.xlsb) ODBC driver could not be found. Please reinstall the driver. And after tha another one: The specified DSN contains an architecture mismatch between the Deiver and Application But the strangest thing is, that when I now return to my app, the query works again - until I close the Excel session. Only this will hardly be an acceptable working solution:-) Any bright ideas?