Querying Excel via OLEDB

  • Thread starter Thread starter Nic
  • Start date Start date
N

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
 
Back
Top