Jet 4.0 ISAM Error

[cultdyn]

I know this is a FAQ because I've spent HOURS reviewing stuff in endless
discussion groups but none of it works for me! I'm getting the "Cannot find
installable ISAM" error when I try to open an ADO connection to an Excel
worksheet.

I am currently grappling with this using VBA but I have had exactly the same
issue when programming in Turbo Delphi. I am using Office 2003 Small Business
Edition.

For info, I've checked, rechecked, retyped and fiddled with the connection
string. I've been through the registry entries for Jet. I've checked I've got
the DLL. I "repaired" Office.

HELP!

 

[cultdyn]

This is me answering myself - and feeling like a bit of a dummy! There was a
SPACE missing in the connection string! Oh well .......