Excel 2003 ODBC driver without support for XML files?

  • Thread starter Thread starter Boris
  • Start date Start date
B

Boris

Can anyone confirm that the Excel 2003 ODBC driver does not support Excel
files when saved in the Excel 2003 XML file format? Or looking at a
connection string:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Test.xml;Extended
Properties=Excel 8.0;

This does not work although the very same file in the XLS format does
work? If that is true is there any recommended workaround (which is
probably another ODBC driver)?

Boris
 
I can confirm this from my own attempts to get this working too. Have you have any further luck? Is there a driver for the Excel XML format in 2007 or 2010 - if so it doens't seem to be there in the default settings.
 
Back
Top