Excel 2007 - Wrong ADO Columns N° notification

Posted 2010-09-24 14:09
by Fabio La Vitola
in the Excel Forum

Hi all,
i hope i'll be clear to explain...
I've an .xlsx file with 339 columns (used for import a wide range of data) but if i ask ADO to tell me how many columns (to check data integrity) i only get 255 (recordcount) using adSchemaColumns.
I'm using VB6.
It's useful for me 'cuase i cand use SQL string to query all data (unknown rows number)
Any ideas ?
Thanks in advance.

Fabio