pass memo field to sql stored procedure parameter

  • Thread starter Thread starter Brett
  • Start date Start date
B

Brett

Using Access 2k, SQL Server 2k, attempting to pass Access
long text (memo) contents as a parameter to a SQL stored
procedure. I can't find a data type to use in the
CreateParameter method. The following works, but limits
the text to the 8000 Varchar limit:

in Access:

..Parameters.Append .CreateParameter("@Note", adVarChar,
adParamInput, 8000, Me.Note)

in SQL Server stored procedure:

@Note varchar(8000) = Null,

What is the data type setting corresponding to the SQL
Text data type? For example,

in Access

..Parameters.Append .CreateParameter("@Note", ???,
adParamInput, , Me.Note)

in SQL Server stored procedure

@Note text = Null,

There is no adText type, and adVarChar or adLongVarChar
without setting a length do not work.

Thanks for the help.
Brett
 
Back
Top