External table is not in the expected format. OWC11

U

Ujval Shah

Hi,

I am facing a peculiar problem. My Client Requirement is to Export and
Import Excel from and To DataSet for web Application using OWC.
Now Problem is When i Export file using OWC .. File's Extension is .xls but
it's XML Spreadsheet .. so when i am trying to import Extended Property=EXCEL
8.0 is not supported. and it gives error

"External table is not in the expected format."

because Excel 8.0 Accept CSV / Excel Workbook format.

And Client Export File using OWC11 only..

So Please suggest if there is anyway to import that file

Thanks in Advance.
 

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

Getting error:External table is not in the expected format.while u 0
Table format - connection string problem 1
OWC11 pivot table export to excel fail: missing tag row (seems to 0
ADO connection to Excel 2007 *.xlsx files? 8
"External table not in expected format" 7
I am using OWC11 in my application. which is merging last cell 0
Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0
import external data as a List (not table) into excel 2010 with excel 2000-2003 list format 0

Top