Excel FieldSize limit

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

LeRoy

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Mail Merge with Excel and Word 2007 1
MS Query Cell Limit 2
How do I get more than 255 characters into a cell? 3
Record Macros in Access 2003? 1
INSERT INTO 5
Exporting files from Access into Excel 1
Field formatting in a table 1

Top