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.Ap pend("Id", DataTypeEnum.ad Integer, 8);
tbl2.Columns.Ap pend("DateTime" , DataTypeEnum.ad Date, 0);
tbl2.Columns.Ap pend("RecordLis t", DataTypeEnum.ad LongVarWChar, 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