External table is not in the expected format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

My program try to export a excel file by using

Response.ContentType = "application/vnd.ms-excel";
Response.Write("<table><tr><td>");

But when i import it back to my system using Oledb, i got an error.

External table is not in the expected
format.System.Data.OleDb.OleDbException: External table is not in the
expected format. at System.Data.OleDb.OleDbConnection.ProcessResults(Int32
hr) at System.Data.OleDb.OleDbConnection.InitializeProvider() at
System.Data.OleDb.OleDbConnection.Open()

Do anyone know how to solve it?
Thx a lot for help.

Simon.
 
Hi Simon
Mostly there is some data type that is sent back to the excel file that is
not expected there. how do you import your file? . If you do any
modifications, make sure that you keep the parameters as expected by the
file.
Mohamed Mahfouz
MEA Developer Support Center
ITworx on behalf of Microsoft EMEA GTSC
 
Back
Top