Excel FieldSize limit

  • Thread starter Thread starter Manju
  • Start date Start date
M

Manju

I am using excel to import data. But, If the field for eg
Desc exceeds 255 Characters, I get the OleDB exception
saying that
"The field is too small to accept the amount of data you
attempted to add. Try inserting or pasting less data."

Is there a way to import more than 255 characters in Desc
field.

Any help is greatly appreciated.

Thanks.
 
Nope, that is the limitation of Excel. If you use Access,
you can set the field to be memo and that will give you
more character space.
 
Back
Top