how to inserting data with stored procedures - classes(編號:1604)

請教各位先進,如何對備忘資料型態(remark in access,or text in sql server 7.0)的DataTypeEnum,到底是
使用adVarChar參數,還是其他的。
Public Function InsertBank(ByVal strRemark As String,
ByRef objConn As ADODB.Connection, _
   ByRef objCmd As ADODB.Command) As Long

  On Error GoTo InsertBank_EH
 
  Dim intIndex As Integer
 
 
  Set objCmd.ActiveConnection = objConn
  objCmd.CommandText = "dbo.up_parins_bankall"
  objCmd.CommandType = adCmdStoredProc
 
  'Append the parameters
  objCmd.Parameters.Append objCmd.CreateParameter("Remark", adVarChar, adParamInput, 50, strRemark)
...