Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
John Young wrote ...
I am trying to connect to Excel, not Access. The OS is Windows NT, and the file was created using Excel 2003. Interestingly, running the same program under Windows 2000 does not generate the ISAM error. The 'Could not find installable ISAM' error message can appear for all sorts of reasons. The most obvious is getting the connection string wrong e.g. change Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Tempo\db.xls; Extended Properties='Excel 8.0;HDR=Yes' ' << correct to Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Tempo\db.xls; Extended Properties='Excel8.0;HDR=Yes' ' << error If the same code works on another machine then you have to look at the differences between the machines. If you are using a DSN rather than a connection string, check both DSNs are the same. The next obvious way of creating the aforementioned error is to change something in the registry e.g. change HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\ISAM Formats\Excel 8.0\Engine=onedaywhen So there could be an issue with the registry. I can't think of any applicable ini files. Hopefully, looking for differences will highlight the problem before you resort to rebuilding the machine. -- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to error trap "... cannot find the data..." message? | Excel Discussion (Misc queries) | |||
ODBC Excel Driver Login Failed. Could not find installable ISAM | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Could not find installable ISAM | Excel Programming | |||
macro error "can't find project or library" | Excel Programming |