ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel 2003 ODBC driver without support for XML files? (https://www.excelbanter.com/excel-programming/395916-excel-2003-odbc-driver-without-support-xml-files.html)

Boris[_8_]

Excel 2003 ODBC driver without support for XML files?
 
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


All times are GMT +1. The time now is 01:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com