Exporting a report to Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Raj - 30 Sep 2005 14:48 GMT

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.

Reply to this Message

Michel Walsh - 30 Sep 2005 17:55 GMT

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

> Dear All,
>
[quoted text clipped - 7 lines]
> Thanks folks..
> -Raj.

Reply to this Message