External table is not in the expected format

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: simon (simon_at_discussions.microsoft.com)
Date: 08/10/04 

Date: Mon, 9 Aug 2004 19:45:12 -0700

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.

Relevant Pages