View Single Post
  #4   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

You can export more than 255 characters from a memo field, as long as
you use Excel97-2003 format.

CyberTaz wrote:
More info is necessary to give meaningful suggestions, but one guess is that
the field involved is a Memo data type containing more than 255 characters.
Each Excel cel is limited to that amount of content, so any excess will not
get copied to the workbook cell.

Text, Number, Date & Time, Hyperlink, Yes/No, Currency data types should not
be a problem. (Although Number fields defined as Decimal size may be a
problem if used to capacity.)

Pardon the basic question, but could it simply be a matter of widening the
columns in the Excel file? |:)

"Sabina" wrote:


When I export my access db to excel (only about 150 records) somehow the data
gets cut off in the cell. Is there a way to fix this?





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html