Querying Excel via OLEDB

[Nic]

Greetings,

I'm accessing an Excel spreadsheet directly via OLEDB and displaying
the results in a datagrid. I've run into an issue where a column
containing lengthy text is being truncated (chopped off) somewhere
between 200-300 charaters (256?). Is this a limitation of oledb/excel
or is there a setting that can fix it? Am I missing something?

Thanks in advance for any guidance.

-Nic

 

[Ken Cox [Microsoft MVP]]

According to the Excel specifications and limits, the column width limit is
255 characters.

http://office.microsoft.com/assista...CTT=1&Origin=EC010229861033&QueryID=EWC64YuO9