tags:

views:

86

answers:

0

Hi.

I'm unable to open XML spreadsheets (2003) using either the JET driver or the new Microsoft.ACE.OLEDB.12.0 provider.

I've tried both Microsoft.Jet.OLEDB.4.0 and Microsoft.ACE.OLEDB.12.0 with and without the "Xml" qualifier in the Extented Properties parameter.

They both throw

OleDbException (0x80004005): External table is not in the expected format.

Microsoft.Jet.OLEDB.4.0 with the "Xml" qualifier throws

OleDbException (0x80004005): Could not find installable ISAM.

Is there no way to open the old XML Spreadsheets with one of these providers??

Thanks.