When reading an Excel file, the following error occurs: The External table is not in the expected format.

Oledbconnection myoledbconnection = new oledbconnection ("provider = Microsoft. jet. oledb.4.0; Data Source = "+ server. mappath (filepath) + "; extended properties = 'excel 8.0; IMEX = 1 '");
Oledbdataadapter myoledbdataadapter = new oledbdataadapter ("select * from [STUDENT $]", myoledbconnection );
Dataset DS = new dataset ();
Myoledbdataadapter. Fill (DS );

WhenProgramWhen running here, the error "The External table is not in the expected format" is displayed.

Solution:
Open your Excel file in notepad to see if it is garbled.
For HTMLCode, Indicates that your Excel file format is not a standard Excel format, and the error "External table is not in the expected format" will be prompted;
If the code is garbled, I will not prompt this error during the test here. You can import it successfully.