Problem using OLEDB connector

[Pranav Nabar]

Hi,
I am trying to insert data into an Excel sheet using Microsoft Jet OLE DB
4.0 driver. One of the fields is exceeding 255 characters. I get the error:

"The field is too small to accept the amount of data you attempted to add.
Try inserting or pasting less data"

This is surely not a problem with Excel since I put in the data manually.
Please let me know if we have a solution/workaround for this.

Thanks,
Pranav.

 

[Paul Clement]

¤ Hi,
¤ I am trying to insert data into an Excel sheet using Microsoft Jet OLE DB
¤ 4.0 driver. One of the fields is exceeding 255 characters. I get the error:
¤
¤ "The field is too small to accept the amount of data you attempted to add.
¤ Try inserting or pasting less data"
¤
¤ This is surely not a problem with Excel since I put in the data manually.
¤ Please let me know if we have a solution/workaround for this.

I believe you are encountering an issue with the Jet provider. See if the following helps:

PRB: Transfer of Data from Jet 4.0LEDB Source Fails with Buffer Overflow Error
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q281517


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)

 

[Pranav Nabar]

Thanks Paul.

-pranav