could not find installable ISAM while trying to insert records in ACCESS RRS feed

  • Question

  • hi,

    I am stuck please help..  getting error "could not find installable ISAM" error while running the below in VB.net..  This was working for 2-3 weeks..suddenly throwing error.. please help

     connstring = " Provider=Microsoft.Jet.OLEDB.4.0; Data Source=d:\Max_Data_Master\test.mdb;"
            cnn1 = New OleDb.OleDbConnection
            cnn1.ConnectionString = connstring
            str = "INSERT INTO test (test1)  SELECT Wh_RMS_Code1  from [Microsoft.Jet.OLEDB.4.0;DATABASE=d:\Max_Data_Master\Autoreplenishment.xls;].[sheet1$]"
            If cnn1.State Then cnn1.Close()
            cmd = New OleDb.OleDbCommand(str, cnn1)

    Monday, December 10, 2012 2:04 PM


  • It looks like you are importing from an Excel Workbook so the connection should specify the Excel driver:

    str = "INSERT INTO test (test1)  SELECT Wh_RMS_Code1  from [Excel 8.0;DATABASE=d:\Max_Data_Master\Autoreplenishment.xls;HDR=Yes].[sheet1$]"

    Paul ~~~~ Microsoft MVP (Visual Basic)

    • Marked as answer by Alexander Sun Thursday, December 20, 2012 7:26 AM
    Tuesday, December 11, 2012 3:19 PM