Why does the DataTable get strings do not exceed 255 charact

Dong Lam Trien

I have a data file called Access 2003 Table The question "TABCAUHOI" has the following fields:

ID int;

NOIDUNG memo;

The "NOIDUNG" field has data type as memo, I pour data from excel text file into this table in this access file to check the contents are full as excel file, in C # I query read data into DataTable dt = query 1 message of a content, when debugging Debug.Print (dt.Rows [0] ["NOIDUNG"]. ToString ()); Only get 255 characters in the first string, characters after 255 characters later lost, want to get everything into the DataTable how to do ?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dong Lam Trien8y ago
I done.
Dong Lam Trien8y ago
I checked the data from excel to access is good but from Table Access to DataTable is not good. From Table access to the DataTable get the first 255 characters, the characters after 255 are lost. Note: I have no excel data error on the table access, I am getting errors from Table access to the DataTable of winform C#
Jenith Thakkar8y ago
The standard max length of a text column in jet is 255 characters. I haven't tried this, but if you create a schema.ini file and tell it that your column is a memo type, you might be able to put more data in.

(Here Jet is following
Excel 97

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\Engines\Excel
Excel 2000 and later versions

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel
)

Use ExcelDataReader and add reference in your project. and use below code to read Excel more than 255 columns...
FileStream stream = File.Open(strFileName, FileMode.Open, FileAccess.Read);

IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);

DataSet result = excelReader.AsDataSet();

excelReader.Close();

return result.Tables[0];

I Hope This will be helpful for you