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

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

[quoted text, click to view]
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 :-)