ERROR [22001] [Microsoft][ODBC Excel Driver] The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data. : DOTNET

This is a discussion on ERROR [22001] [Microsoft][ODBC Excel Driver] The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data. within the DOTNET forums in Framework and Interface Programming category; Hi, I'm using ODBC DSN less connection to load an EXCEL file into a dataset. It's raising the error "ERROR [22001] [Microsoft][ODBC Excel Driver] The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data." The problem is one of the column in a excel sheet is having a data of lenght more that 260 chars. How to load an excell sheet whose cells are having lengthy text(around 400 chars)? Thanks in advance. Gopinath Munisifreddy...