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
 
M

MichaelCousins

Joined
Aug 12, 2011
Messages
1
Reaction score
0
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.
 

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

VBA Excel data to SQL Sever table 1
Excel, Microsoft Jet and OLE-DB 7
[Excel2007] How to obtain provider name for ADODB.Connection 4
tuncating a table in sql from excel 1
Extracting Data Without Opening Workbooks 2
QueryTables.Add Connection Parameter 0
OleDb Excel 12.0 bug 1
provider strings for CSV files? 4

Top