I need to export a query to Excel with a memo field. The memo field
keeps getting cut off at 255 characters. If I just cut and paste, I
get the whole memo field.

I need it in Excel without having to go through all that. Any ideas?

Thanks!
Laura

I think you have to change tack a little and export from a table to get all
your memo data.

One way would be to create a make table query and then export from that.

Peter





"musicloverlch" <lhowey@gmail.com> wrote in message
news:1144683025.180825.196700@z34g2000cwc.googlegr oups.com...[color=blue]
>I need to export a query to Excel with a memo field. The memo field
> keeps getting cut off at 255 characters. If I just cut and paste, I
> get the whole memo field.
>
> I need it in Excel without having to go through all that. Any ideas?
>
> Thanks!
> Laura
>[/color]