truncation of fields inported from access

L

liddleti

How do I work around the 255 character truncation of text fields in excel. I
am exporting from access to excel and loosing text.
 
S

Spiky

How do I work around the 255 character truncation of text fields in excel. I
am exporting from access to excel and loosing text.
Click to expand...

Try formatting the cells as General. Versions as old as Excel 2000 can
have far more characters than this in a cell, but you may need to
change out of Text format, I forget exactly how this works.

Excel 2007 is unlimited or something like that, if upgrading is an
option.
 
Top