Reading ntext and text data types in Access

A

alsmith2917

I have exported some Access 97 Tables to SQL Server 2000.
In creating the table in SQL Server, the import/export
wizard creates a memo field as ntext. From my
understanding, Access 97 does not support unicode data. So
when opening the table in Access, it truncates data from
the beginning of the field.If I try changing it to a text
field, I recieve ODBC Call Failed messages. It appears in
SQL fine..Anyone have suggestions?
 
Top