Could not find installable ISAM

[tjmccune]

I am using Excel 2003 and I am trying to send some data
to Access 2003 with DAO. I get the message 'Could not
find installable ISAM' when I trying to append my data.
I've found several papers about this problem on
Microsoft's support site, but none of the solutions has
worked for me so far. (Make sure msexcl40.dll is in the
right directory, make sure it isn't corrupted). Does
anyone know what else I might try?
I used Office97 before and I never had any trouble with
this. With Office 2003, I can't control the install to
see what kind of database sources I am going to work
with. I do have msexcl40.dll, it's fresh off the
install, and the registry key looks right.

 

[onedaywhen]

What connection string are you using?

 

[tmccune]

I finally figured it out!! I assumed that since I was
using Excel 2003 (version 11.0), my connection string
would need myTable.connect = "Excel 11.0;DATABASE..."
That wouldn't work. So, I put in Excel 8.0 (what I used
for Excel 97, and it did work! Not necessarily
intuitive, but I am past that problem now.

 

[Jake Marx]

Linda,

Did you ever find the answer to your problem? I'm facing the same
error when using Visual Basic to open an Excel file...

I can't find the original message that you're replying to. What does your
connection string look like?

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]