Click here to Skip to main content
15,849,996 members

Comments by Jacobb Michael (Top 1 by date)

Jacobb Michael 31-Aug-10 5:04am View    
Thank you for the Ref:

string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + filename + ";" +
"Extended Properties=Excel 8.0;";
OleDbConnection objConn = new OleDbConnection(connectionString);

this is the connection string used in that example it is similar to the connection string what i have created.

and still i get "External table is not in the expected format" error.