Re: OpenSchema(adSchemaTables) from Excel 2007 returns nothing

Ralf Ziller wrote:
If I connect via ado in VBA in Excel 2007 to an Excel ***
(Provider=Microsoft.Jet.OLEDB.4.0;Data Source="C:\test.xls";Extended
Properties="Excel 8.0;HDR=No;") and call
Set RS = conn.OpenSchema(adSchemaTables)
the Recordset is empty. If I run the same code in Excel 2003 the
Recordset gets filled with the expected data.
Is there a way that I can use the code out of Excel 2007?
I do not want to open the Excel *** as I just need to copy data
from the *** which is much much faster via ADO than to actually
open the excel ***.

I've never used OpenSchema against Excel so I'm a little surprised it
returned anything usable. Did it define worksheets as tables?

Anyways I suspect the spread*** structure changed in Exel 2007 and,
since ADO is out of support, the OLEDB provider was not updated to
handle that change. Sorry, I have nothing else to suggest.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.