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.
 

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

Add additional information to excel form after original data entry 0
Function to find truncated entries? 3
Template with fields and premade texts.. 0
Access form continuous 1
Range headings 0
Default local file location - folder redirection slowness 0
Long Data Fields in Mail Merge 0
Force data type from Text to Memo in a simple Make Table Query 1

Top