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.
 

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
MS Query Cell Limit 2
Make Table Query Truncating Memo Field at 255 Characters 2
Mail Merge with Excel and Word 2007 1
Export to Excel Cuts Off Data 1
How do I get more than 255 characters into a cell? 3
INSERT INTO 5
Record Macros in Access 2003? 1

Back
Top