External table is not in the expected format

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.
 
M

Mohamoss

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"External table not in expected format" 7
External table is not in the expected format 0
Exporting to Excel (xlsx files) 3
Exporting to Excel using new version of Excel 1
Export datagrid to excel 1
invalid path error while accessing FOXPRO table from c# 4
Can't import Paradox 5 tables - "...not in the expected format" 4
External table is not in expected format 1

Top