Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Field is too small to accept the amount of data

Field is too small to accept the amount of data

Field is too small to accept the amount of data

I have an excel spreadsheet with the columns:


Description contains text, with the most words being 41 (248 characters).  

I am getting a failed to open a rowset error with the following:
DAO Error Code: 0xc5b
Source DAO.Databaase
Description: The field is too small to accept the amount of data you attempted to add. Try instering or pasting less data.

How can this be?  Is there a way around this?  Crystal keeps crashing on me in this report when I try to add a field or a group.  

Using CR9 and Excel 2003.  Thanks!


RE: Field is too small to accept the amount of data

The maximum size of an xl cell is 255 characters.
I supect that your max data size must be more than this.

(Are you counting spaces in your 248?)

It sounds like you must be building the string that is exported in a formula.  If so I suggest, for testing purposes,  you create another formula field which just displays the length of the string.

evaluateafter ({@formula})

and put this into yur detail line to see what is happening.
(Use the Highlightin Expert to highlight any values >255?)

RE: Field is too small to accept the amount of data

I did have fields larger than 255.  I split them out into two fields.  HOWEVER, it keeps crashing on me whenever I add a field (text, report, anything).  I am installing the service pack right now and I hope that helps.  I have already unistalled and reinstalled CR twice.  


RE: Field is too small to accept the amount of data

I just placed 300 chars into a Excel 2000 spreadsheet, and used CR 9 to open and display the data with no trouble.

I do have the latest Service Pack applied.

Keep in mind that Excel is a horrible data source, and that drivers reading it often get confused because of the poor data typing Excel supplies.

It may be that the first row of the spreadsheet is a number, such as 1. Excel in it's infinite ignorance will now decide that the column is a numeric when queried by external sources.

I've had to insert a fake row of data as the first row to force correct data typing in Excel.

Anyway, you now know that it has NOTHING to do with a 255 limitation, and that it does work in your environment.


RE: Field is too small to accept the amount of data

Sorry - I was getting confused with column width in talking about cell size - for XL2003 the cell contents can be 32k characters.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close