Exporting a report to Excel

R

Raj

Dear All,

I have an access report exported to a excel spreadsheet. Everything works
fine, but the content data gets restricted somewhere. For eg., I have a
comment field with datatype memo in access, if i export to excel am not
getting the full data exported. I am not sure where am doing wrong.

I would appreciate any help.

Thanks folks..
-Raj.
 
M

Michel Walsh

Hi,


If you pass through some more or less complex query, your memo may be
truncated to 255 char, to fit in a varchar field (or text field, like Jet
call them),


Hoping it may help,
Vanderghast, Access MVP
 
Top