When Excel ODBC driver is used to read more than 255 characters, data may be truncated.

Problem:

When you use the Microsoft Excel ODBC driver to read fields that exceed 255 characters in an Excel file, the returned string is truncated to 255.

 

Cause:

By default, the Microsoft Excel ODBC driver checks the first eight rows to check whether the fields contain more than 255 characters. If there are fields, the above problems will not occur. If not, the system will qualify.

 

Solution:

1. Add a dummy field with more than 255 characters in the first eight rows

 

2. Modify the registry and change the check value of the default number of rows.

 

For more information, see:

Http://support.microsoft.com/kb/189897