dkmarsh
asked on
how to handle memo fields in sql server
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 ?
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 ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.