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


External Data Import - Major problem

External Data Import - Major problem

External Data Import - Major problem

Hi All,

I have read many posts about the external data imports. I am importing Excel spreadsheets into tables. I have created the tables in Access already, and have defined the columns as Memo fields when the excel cells contain paragraphs. Yet, when I run the reports, the cut at 255 charchters, as if they were text fields. I have all these student reports to generate, and all the text from the teachers is being cut off. How can I guarantee that the inport will be expressed as a memo and not a text field.

Thank you all for your help as I am in a major time crunch.

RE: External Data Import - Major problem

There is a further problem here. I just ran a simple report with two of the fields that are cut ff in my main report, and in a basic report, all the information displays. How can the same table generate a correct field in one report and a cut field in another?

RE: External Data Import - Major problem

It isn't clear if the full memo value is actually in the table or not. Is this just a problem of displaying the full value in a report/query?

If it's only an issue within the report, what section of the report contains the text box displaying the memo field? I expect it might be a group header.

Hook'D on Access
MS Access MVP

RE: External Data Import - Major problem


For every subject (math, science, history etc...) there are long narratives in memo fields. Every header has at least two or three memo fields that are being cut off. The full memo field is in the table, I tested them all. So every header section has a few memo fields within it that are not displaying correctly. Does that make more sense to you?

Thank you kindly for any advice you can offer me.


RE: External Data Import - Major problem

Make sure the text boxes:
- Can Grow
- Are in a section that Can Grow
- Don't have anything in the Format property

If this still doesn't work, you might need to use a subreport in the group header to display all of the memo value.

Hook'D on Access
MS Access MVP

RE: External Data Import - Major problem




RE: External Data Import - Major problem

The issue apparently was an @ symbol in the Format property of the text boxes that displayed the memo field(s). Anything in the Format property of a text field has the possibility of limiting the display to 255 characters.

Hook'D on Access
MS Access MVP

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