Results 1 to 4 of 4

could not find installable isam

Threaded View

  1. #1
    Registered User
    Join Date
    04-22-2014
    Location
    pune
    MS-Off Ver
    Excel 2013
    Posts
    2

    could not find installable isam

    I'm using below code to write access data in new worbook and the below code works fine

    MyConn="C:\Users\shariqk\Desktop\Document\BT\Access Test\BT SAMPLE.mdb"
    sSQL= "SELECT " & TableCOl & " INTO [Data] IN '' [Excel 8.0;Database=" & ActiveWorkbook.Path & "\book1.xls] FROM " & Tablename & ";"
       Set Cn = New ADODB.Connection
        With Cn
            .Provider = "Microsoft.Jet.OLEDB.4.0"
               .Open MyConn
            Set Rs = .Execute(sSQL)
        End With
    but when i want data is new version of excel(coz my data is more tan 65k), i'm getting ISAM error. below is the code

    MyConn="C:\Users\shariqk\Desktop\Document\BT\Access Test\BT SAMPLE.mdb"
    sSQL= "SELECT " & TableCOl & " INTO [Data] IN '' [Excel 10.0;Database=" & ActiveWorkbook.Path & "\book1.xlsx] FROM " & Tablename & ";"
       Set Cn = New ADODB.Connection
        With Cn
            .Provider = "Microsoft.Jet.OLEDB.4.0"
               .Open MyConn
            Set Rs = .Execute(sSQL)
        End With
    Please help.
    Last edited by arlu1201; 04-22-2014 at 07:58 AM. Reason: Use code tags.

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 nemPyong in forum Excel General
    Replies: 0
    Last Post: 09-06-2013, 07:22 AM
  3. Could not find installable ISAM
    By matthew1404 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-19-2013, 05:37 AM
  4. 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
  5. Could not find installable ISAM? Error
    By cyildirim in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-09-2008, 04:56 AM

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