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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Access form with SQL Server Append Query 0
Form to update SQL SErver nText field 0
Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0
Can you cast ntext into text so you can use group by? 3
Access Repeats First Row Of Data 4
Convert a Number field to Autonumber? 15
Exporting query or report to Excel results in Text field data loss 8

Top