C# and creation of Access database

[booyeeka]

Hi all!

I need to create MS Access database table row, that have to store "long text" in it.

What type of field I have to use?

I tryed with adLongVarWChar, but it stores only 250 or something characters

Table tbl2 = new Table();
tbl2.Name = "TrackerValues";
tbl2.Columns.Append("Id", DataTypeEnum.adInteger, 8);
tbl2.Columns.Append("DateTime", DataTypeEnum.adDate, 0);
tbl2.Columns.Append("RecordList", DataTypeEnum.adLongVarWChar, 0);

Please if you can help me with this.

Thank you in advance!

[akshaycjoshi]

Select MEMO datatype in your Access database.

[booyeeka]

tnx, but i have to create that table using c#, and not with access