I have one table in MS-Access having memo field. Though it is memo field
it's not pointing any file but has text data which is displayed on a running
Now we are migrating the MS-Access database to SQL Server 2000. How can I
import these data directly into SQL database? Which datatype should be in
SQL database for it?
A Memo field can store up to 65,536 characters. If there is no direct way to
import and use these data then pl. guide me how to use "text" data type in
SQL server including text pointer as I never used it before and also i
didn't find any example for it.