Why the excel file not opening using this code? error occurs

Question

    ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;   Data Source='" + fileName + "';  Extended Properties=Excel 5.0"        

    Dim ExcelConnection As System.Data.OleDb.OleDbConnection
    ExcelConnection = New System.Data.OleDb.OleDbConnection(ConnectionString)

    ExcelQuery = "Select * from [Sheet2$]"
    Dim ExcelCommand As New System.Data.OleDb.OleDbCommand(ExcelQuery, ExcelConnection)
    ExcelConnection.Open()

    Dim ExcelReader As System.Data.OleDb.OleDbDataReader
    ExcelReader = ExcelCommand.ExecuteReader()

    While (ExcelReader.Read)


    End While
    ExcelConnection.Close()
    ExcelReader.Close()

Error occurs on line

         ExcelConnection.Open()
       External table is not in the expected format.

PLease help
Thank you

Please show us the connection string. Possible duplicate of http://stackoverflow.com/questions/1139390/excel-external-table-is-not-in-the-expected-format — Olaf, Jun 12 '11 at 10:48

score 2 · Accepted Answer · edited May 23 '17 at 12:12

2

Use

public static string connStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileName + ";Extended Properties=Excel 12.0;";

as your connection string. Find more information here: Excel "External table is not in the expected format.".

edited May 23 '17 at 12:12

Community

1
1

answered Jun 12 '11 at 11:05

Olaf

10,049
8
38
54

Why the excel file not opening using this code? error occurs

1 Answers1