External table is not in the expected format. OWC11

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ujval Shah - 23 Nov 2006 09:13 GMT

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.

Reply to this Message

Cindy M. - 24 Nov 2006 14:37 GMT

Hi =?Utf-8?B?VWp2YWwgU2hhaA==?=,

> I am facing a peculiar problem. My Client Requirement is to Export and
> Import Excel from and To DataSet for web Application using OWC.
[quoted text clipped - 7 lines]
>
> And Client Export File using OWC11 only..

I guess you could transform the XML to CSV. Or you need to use a different OLE
DB provider (one for XML) to import the data.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

Reply to this Message

Rate this thread:

External table is not in the expected format. OWC11

Free Magazines