Field Length in importing access data base

Assaf_m

Hi everyone,

I'm trying to import access database which is linked to outlook emails, however, the field content (email body) is not showing all information, is there a limit in the field length reading access database? as in Microsoft access itself, I can see the full content of the email body.

danilang

Hi @Assaf_m 

Can you post a screen shot of where you're seeing the truncation.  If it's in a standard Browse Anywhere results window only the first 256 chars are displayed and you get the "This cell has truncated characters" message

Any tool other than a Browse result window

If you add a Browse tool, the results show the entire string and the message changes to "This cell has >256 characters" 

Browse results window

The underlying field is never actually truncated as you can see by the StringLength field.  It just the display that is limited to conserve memory.

Dan