how to handle memo fields in sql server

dkmarsh
dkmarsh used Ask the Experts™
on
I have an access database that I have converted to SQL Server.

A column in the Access table was memo and the conversion tool chanbged it to nvarchar(max).

When I create a linked table from access to sql server, it says that the column is text(255) rather than memo.

How do I setup the linked table so that the column shows as memo in access ?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
I haven't seen this before, but this walks thru exactly the problem you are having:
http://forums.asp.net/t/901002.aspx

basically, it was an import from Access to SQL of a memo field, which defaults to 255 in SQL, but once the user worked around the 255 default, it seems everything was fine

this is also very interesting regarding the memo field:
http://allenbrowne.com/ser-63.html

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial