error hy000 microsoft odbc excel driver external table is not in the expected format

Error Hy000 Microsoft Odbc Excel External Table Is Not In The Expected Format Code Snippet Work

When I run the program on the original spreadsheet (not produced by me, I can only access it) it errors out giving me this error:System.Data.OleDb.OleDbException: External table is not in the expected format.

I create odbc at control panel with microsoft excel driver (.xls).

Error Hy000 Microsoft Odbc Excel External Table Is Not In The Expected Format Code Snippet Work

The following code snippet work fine under VS 2005, but it throws an exception: System.Data.OleDb.OleDbException: External table is not in the expected format.under VS 2003, ASP 1.1 when trying to open the connection.

Does anybody know whats wrong And where should I look for answers Am I doing something wrong from ASP, or my excel file is the one to blame Help me out, pls.

System.Data.OleDb.OleDbConnection cn;System.Data.OleDb.OleDbDataAdapter cmd;System.Data.DataSet ds new DataSet();cn new System.Data.OleDb.OleDbConnection(provid.

All I am doing is trying to open the connection as you can see.

And I get the error External table is not in the expected format.

Please help, ASAPThanxProtected Sub PageLoad(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load.

ProviderMicrosoft.Jet.OLEDB.4.0;Persist Security InfoFalse;Data Source ptableName;Extended PropertiesExcel 8.0;HDRYES.

OleDbConnection(Dat.

External table is not in the expected format.

Currently Reading Data from Excel.

When i am using Excel 2003 work book, i dont have no problem.

But when i use Excel 2007 format i am getting following error.

Description: An unhandled exception occurred during the execution of the current web request.

Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: External table is not in the expected format.My code:string connection ProviderMicrosoft.Jet.OLEDB.4.0;Data SourceC:Test.xlsx;Extended.

I am getting an error with a excel 2007 when exporting information file but the thing is that the excel file contains 23 columns when I remove three of them the code works fine.

Dim strConn As String ProviderMicrosoft.ACE.OLEDB.12.0; Data SourceC:ACTIVE - ROSTER.xlsx.

Extended PropertiesExcel 12.0;HDRYESDim myData As New OleDbDataAdapter(SELECT FROM ACTIVE, strConn).

I am trying to connect the following oleDBconnection in VS 2005.

But it doesnt throw an exception--External table is not in the expected format.

But whe. while Import data to Excel Sheet Error:External Table is not in the expected format.

Reading worksheet names from excel 2003 gives error External table is not in the expected format.

Im just trying to return the worksheet names from excel spreadsheet.public static string ReadExcelWorksheetnames().

DataTable dt connection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);worksheetnames new stringdt.Rows.Count.

Add the. Strange Error from Excel to C I have an excel spreadsheet, and some oledb commands.

Error Hy000 Microsoft Odbc Excel Driver External Table Is Not In The Expected Format