Problem using OLEDB connector

  • Thread starter Thread starter Pranav Nabar
  • Start date Start date
P

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.
 
¤ 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)
 
Back
Top