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. InputSheet). 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. 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?
Thanks in advance!


Arvi Laanemets