LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 459
Default "Can't Find Installable ISAM" error

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to error trap "... cannot find the data..." message? [email protected] Excel Discussion (Misc queries) 4 August 29th 08 02:57 AM
ODBC Excel Driver Login Failed. Could not find installable ISAM JustMe@Yahoo Excel Discussion (Misc queries) 0 July 16th 06 07:18 AM
HELP on "left","right","find","len","substitute" functions serene83 Excel Discussion (Misc queries) 5 June 27th 06 02:23 AM
Could not find installable ISAM [email protected] Excel Programming 3 April 22nd 04 09:17 PM
macro error "can't find project or library" Meinfs Excel Programming 3 September 14th 03 04:29 PM


All times are GMT +1. The time now is 10:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"