Excel 2003 ODBC driver without support for XML files?

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADO connection to Excel 2007 *.xlsx files? 8
VBA Excel data to SQL Sever table 1
[Excel2007] How to obtain provider name for ADODB.Connection 4
ADO connection not opening in Excel 2003 0
Word 2013 merge Excel, DDE conncetion path problem 0
tuncating a table in sql from excel 1
Extracting Data Without Opening Workbooks 2
Excel, Microsoft Jet and OLE-DB 7

Top