ExcelBanter - Text via ODBC truncated at 255 characters

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Text via ODBC truncated at 255 characters (https://www.excelbanter.com/excel-programming/395273-text-via-odbc-truncated-255-characters.html)

Walter

Text via ODBC truncated at 255 characters

I am using ADO to retrieve data from a column in a SQL Server database used
by Project Server 2003. The column's data type is ntext. When I retrieve
this data, it is truncated at 255 characters. I need to retreive it all.
Does anybody have any suggestions on how to fix this?

Thanks,

Walter

All times are GMT +1. The time now is 07:05 AM.