I tried sheets sved by Excel 2002 (XP) but the schema is
not acceptable by .Net.
If I use ReadXML(FilePath, ignorSchema or AUTO, it fails
to read the Excel XML file into the dataset.
Do you have any suggestions, and is Excel 2003 address
this issue?

Nabil Elibiary wrote:
I tried sheets sved by Excel 2002 (XP) but the schema is
not acceptable by .Net.
If I use ReadXML(FilePath, ignorSchema or AUTO, it fails
to read the Excel XML file into the dataset.
Do you have any suggestions, and is Excel 2003 address
this issue?


When you save a workbook in XML format you are saving almost all the
information about the workbook, including names, styles, numberformats,
alignment, colour, ...

Excel 2003 Professional does provide the ability to just save nomimated
data in XML format. It is probably what you are looking for.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup