>Creating a memory Recordset, I need a field to be Memo data type
>like the example below. Is there such data type as adMemo?
>I checked the help file but couldn't find it. Any advise? Thanks.
>
> Set rstMemory = New ADODB.Recordset
> With rstMemory
> .CursorLocation = adUseClient
> .LockType = adLockPessimistic
> .Fields.Append "TypeCode", adChar, 20
> .Fields.Append "TypeName", adChar, 50
> .Fields.Append "Amount", adCurrency
> .Fields.Append "Remarks", ????? (need a Memo data type)
> .Open
> End With

According to http://msdn.microsoft.com/library/officedev/off2000/acdatComparisonDataTypes.htm, you should use adLongVarWChar.