Can't pull data from ntext field into recordset.
I needed to import data from another table into an ntext field. The source field was also ntext.
After getting the data imported, I can't pull the data from that field into the recordset, into the variable.
Features = oRS("Features")
This returns nothing, but I can go into MS-SQL Query Analyzer and see the data is in the table.
If I change the data type to varchar, I can pull the data into the recordset but because of the length of the data in that field, the data is truncated.
Does anyone know why this is happening and how I can resolve it?