onedaywhen wrote:
"Jake Marx" wrote in message
...

I don't think you can force Excel to grab all data without using a
workaround. The ODBC driver scans the first 8 rows of data in each
column to determine the data type.

The quoted 8 rows is a registry setting:

Hkey_Local_Machine/Software/Microsoft/Jet/4.0/Engines/Excel/TypeGuessRows

Setting the value to 0 (zero) should force ADO to scan all column
values before choosing the appropriate data type.

Right - and point #2 in my post and the second KB article referred to this
workaround.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]