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

[quoted text, click to view]

¤ 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)?

I believe that 255 characters is the limit when performing an Insert into an Excel column using the
data access drivers.


Paul ~~~ pclement@ameritech.net