Very Computer

Hello:
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
web-site directly.

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.

Thanks
Aruna

If the length of the data is more than 8000, you have to use text datatype.
You have to use WRITETEXT/UPDATETEXT to insert and update data into
a COLUMN of text datatype. Check UPDATETEXT on SQL Server Books Online and
you can see more infomation with implementation details and associated
examples

- Anith

Quote:> Hello:
> 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
> web-site directly.

> 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.

> Thanks
> Aruna