Excel FieldSize limit

[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.

[LeRoy]

Excel FieldSize limit

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.[color=blue]
>-----Original Message-----
>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.
>.
>[/color]