-4

Why the code is not running.

Exporting mdb file to excel file

   Dim con As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\User\Documents\jjj.mdb")
    con.Open()


    'New sheet in Workbook
    Dim AccessCommand As New System.Data.OleDb.OleDbCommand("SELECT * INTO [Excel12.0;DATABASE=C:\Users\User\Music\Book11.xls;HDR=NO;].[Sheet7] from [jj] ", con)

    AccessCommand.ExecuteNonQuery()
    con.Close()
Vigines John
  • 17
  • 4
  • possible duplicate of [Open an Excel 2003 spreadsheet with C#. Could not find installable ISAM. Exception](http://stackoverflow.com/questions/644331/open-an-excel-2003-spreadsheet-with-c-could-not-find-installable-isam-excepti) – Ňɏssa Pøngjǣrdenlarp Apr 02 '15 at 12:13

1 Answers1

0

I ever got errror "Could not find installable ISAM" in VB6. But I'm not sure this error is same mine. My solution is re-install visual studio and select all "Data-Access" option and it has been solved. Please see link below for yours. And I'll add other link if I found

Glorfindel
  • 21,988
  • 13
  • 81
  • 109
Monkawee Maneewalaya
  • 140
  • 1
  • 1
  • 14