+ Reply to Thread
Results 1 to 28 of 28

Error message" Could not find installable ISAM"

  1. #1
    Forum Contributor
    Join Date
    06-20-2013
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2007
    Posts
    106

    Exclamation Error message" Could not find installable ISAM"

    Please Login or Register  to view this content.
    In my immediate window I type:
    Please Login or Register  to view this content.
    Then I press Enter in the immediate window.

    Why do I get this error message "Could not find installable ISAM"??

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,696

    Re: Error message" Could not find installable ISAM"

    Is this helpful?

    http://social.msdn.microsoft.com/For...stallable-isam


    If this doesn't help, then Google: could not Find Installable ISAM

    When I did, I got many many many hits.
    Last edited by alansidman; 07-17-2013 at 10:10 AM.

  3. #3
    Forum Contributor
    Join Date
    06-20-2013
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2007
    Posts
    106

    Re: Error message" Could not find installable ISAM"

    I also get an error on this line:

    Please Login or Register  to view this content.
    The error is:
    Run-time error '3709'
    The connection cannot be used to perform this operation. It is either closed or invalid in this context.

  4. #4
    Forum Contributor
    Join Date
    06-20-2013
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2007
    Posts
    106

    Re: Error message" Could not find installable ISAM"

    Alan, I declared a new String variable, strConnectionString, in Access VBA and wrote this:

    Please Login or Register  to view this content.
    I changed the OLEDB to 14.0 instead of 12.0. I read that from the website you just posted. Not sure if that's right though. Because I get the run-time error '3709' still from my post #3.

  5. #5
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,696

    Re: Error message" Could not find installable ISAM"

    This is not my area of expertise, but again, I went to google and found the following for the runtime error 3709

    http://social.msdn.microsoft.com/For...in-any-record-

    Hope you have luck with resolution

  6. #6
    Forum Contributor
    Join Date
    06-20-2013
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2007
    Posts
    106

    Re: Error message" Could not find installable ISAM"

    Thanks Alan. Hopefully someone else replies!

    I get the same error on this line:

    Please Login or Register  to view this content.
    The error is:
    Run-time error '3709'
    The connection cannot be used to perform this operation. It is either closed or invalid in this context.

  7. #7
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Error message" Could not find installable ISAM"

    you ought to be using ACE.OLEDB.12.0 (there is no version 14) and the Else part of your code ought to use the same provider and connection information except the extended properties should read ""Excel 12.0 Macro;HDR=YES"";
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  8. #8
    Forum Contributor
    Join Date
    06-20-2013
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2007
    Posts
    106

    Re: Error message" Could not find installable ISAM"

    This is the Else part of my code...

    Please Login or Register  to view this content.

  9. #9
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Error message" Could not find installable ISAM"

    Please Login or Register  to view this content.
    otherwise strdb is treated as a literal string rather than a variable

  10. #10
    Forum Contributor
    Join Date
    06-20-2013
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2007
    Posts
    106

    Re: Error message" Could not find installable ISAM"

    I changed that line and I still get an error on this line:

    Please Login or Register  to view this content.
    Error 3709

  11. #11
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,581

    Re: Error message" Could not find installable ISAM"

    What exact code are you now using and what's the error message?
    If posting code please use code tags, see here.

  12. #12
    Forum Contributor
    Join Date
    06-20-2013
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2007
    Posts
    106

    Re: Error message" Could not find installable ISAM"

    Please Login or Register  to view this content.

    My error message is on this line
    Please Login or Register  to view this content.
    Run-time error '3709'
    The connection cannot be used to perform this operation. It is either closed or invalid in this context.

  13. #13
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,581

    Re: Error message" Could not find installable ISAM"

    Are you sure the correct connection is being used?

    That's determined by the name of the file you are pasing to the sub.

  14. #14
    Forum Contributor
    Join Date
    06-20-2013
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2007
    Posts
    106

    Re: Error message" Could not find installable ISAM"

    So you're saying I need to have my connection be the .accdb or .mdb file instead of this line

    Please Login or Register  to view this content.
    so it should be like this?

    Please Login or Register  to view this content.

  15. #15
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,581

    Re: Error message" Could not find installable ISAM"

    No I'm saying that strFilename, the argument passed to the sub, is determining which connection string is being used.

    What is it you are trying to do?

    Do you need the code that determines which connection to use?

    Are you using this code for both databases and Excel files?

  16. #16
    Forum Contributor
    Join Date
    06-20-2013
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2007
    Posts
    106

    Re: Error message" Could not find installable ISAM"

    I'm trying to read an Excel file from Access without opening the Excel file. I need to make a connection between the Access database and the Excel workbook. I would like to use this for Access in VBA, if it can also work the other way around that would be excellent.

  17. #17
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,581

    Re: Error message" Could not find installable ISAM"

    Why not just create a link to the Excel file in the database?

  18. #18
    Forum Contributor
    Join Date
    06-20-2013
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2007
    Posts
    106

    Re: Error message" Could not find installable ISAM"

    I could do that, but I wanted to use VBA so that when my data changes so does my Excel file. The Access link to Excel means that I can't change anything in the Excel file from Access directly.

  19. #19
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,581

    Re: Error message" Could not find installable ISAM"

    Using VBA won't mean the data in Excel is updated when you make a change in Excel, unless you actually executed code to update.

  20. #20
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Error message" Could not find installable ISAM"

    it's not real clear which file you are actually trying to open but perhaps

    Please Login or Register  to view this content.

  21. #21
    Forum Contributor
    Join Date
    06-20-2013
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2007
    Posts
    106

    Re: Error message" Could not find installable ISAM"

    When I run it again with my file "ExcelFromAccess.xlsm" the error is: "Cannot update. Database or object is read-only"

    For these lines:

    Please Login or Register  to view this content.
    The error is on the .Open statement

  22. #22
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,581

    Re: Error message" Could not find installable ISAM"

    If you are passing the path and filename you will get that error probably because you are setting the data source to this.
    Please Login or Register  to view this content.
    Which comes out as this when I pass 'C:\Test\adotest.xlsm' to the sub.

    C:\Users\Norie\Documents\C:\test\adotest.xlsm

    If you want to pass the path and filename change the connection string to this.
    Please Login or Register  to view this content.

  23. #23
    Forum Contributor
    Join Date
    06-20-2013
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2007
    Posts
    106

    Re: Error message" Could not find installable ISAM"

    I get this error message now

    Run-time error '3265'
    Item cannot be found in the collection corresponding to the requested name or ordinal.

    Here is the line it breaks on:
    Please Login or Register  to view this content.
    I changed this line:
    Please Login or Register  to view this content.
    And changed this line:

    Please Login or Register  to view this content.

  24. #24
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,581

    Re: Error message" Could not find installable ISAM"

    Well looks like you are getting connected at least.

    Now to sort out the problem with the query.

    Does your Excel file have a field called 'Excel Version' on 'Sheet1'?

    Can you upload the file?

  25. #25
    Forum Contributor
    Join Date
    06-20-2013
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2007
    Posts
    106

    Re: Error message" Could not find installable ISAM"

    I can't upload the file because it's work related. But I can tell you that my Excel field name is called "Volume" on Sheet1. The actual name of Sheet1 is "Errors_Universal"

  26. #26
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,581

    Re: Error message" Could not find installable ISAM"

    So why do you have this SQL which is looking for a sheet called 'Sheet1',
    Please Login or Register  to view this content.
    and this which is looking for a field called 'Excel Version'?
    Please Login or Register  to view this content.
    PS We never need, or want, to see the actual file. Something with dummy data is fine as long as it reflects the original in layout etc.

  27. #27
    Forum Contributor
    Join Date
    06-20-2013
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2007
    Posts
    106

    Re: Error message" Could not find installable ISAM"

    Please Login or Register  to view this content.
    I changed the code to reflect my Excel worksheet. I would usually make a dummy sheet, but I'm in the middle of working on a project related to this. I can make a dummy sheet for you, but I think you already made one. The "Volume" column is all integers.

  28. #28
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,581

    Re: Error message" Could not find installable ISAM"

    If Volume is all integers why are you searching for a string, 'Excel 2007'.

    I did make a dummy file, where Sheet1 had 2 fields - Field1 and Excel Version.

  29. #29
    Forum Contributor
    Join Date
    06-20-2013
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2007
    Posts
    106

    Re: Error message" Could not find installable ISAM"

    Please Login or Register  to view this content.
    So the line rst(1).value refers to the first column of my Excel worksheet which is "AreaID". So AreaID has now changed to "ME" in the first row where it finds Volume = 13

    It works!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 08-22-2014, 03:29 PM
  2. Could not find installable ISAM
    By matthew1404 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-19-2013, 05:37 AM
  3. Could not find installable ISAM when switching between windows 7 and xp.
    By msfarrar in forum PowerPoint Formatting & General
    Replies: 0
    Last Post: 01-16-2013, 04:54 PM
  4. Could not find installable ISAM? Error
    By cyildirim in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-09-2008, 04:56 AM
  5. [SOLVED] ODBC Excel Driver Login Failed. Could not find installable ISAM
    By JustMe@Yahoo in forum Excel General
    Replies: 1
    Last Post: 07-16-2006, 01:50 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1