Hi this is a thread from another news group that has not been
answered. Any ideas anyone?
Thank You, Thank You...you hit it right on the money. It seems SQL
import/export converted all my MS-Access memo fields to the SQL ntext
data type. Does SQL Server have a comparable memo field type? If not
how do people get around the memo field requirement? Create text field
large enough for the average requirement?
On Thu, 17 Jun 1999 16:40:30 +0400, Alexey Dolganov
>Your data (at least one column in the table you are quering) imported into
>MS SQL as Unicode text (ntext datatype). So you cannot request the data
>To avoid this problem you should first change column datatype from ntext
>to text, if you really don't want to use unicode.
>Other workaround is to use osql instead of isql and newer ODBC drivers