Gina,

I first tried just pulling my report. Then clicked export and tried to dump
data in excel 1997-2003 and the other version of excel. It cut off probabbly
after 255 characters when it transfered it to excel.

I have tired the transferspreadsheet method but that did not seem to work
for me. I was thinking there had to be an easier way then what i was doing.
The only time it fully copied everything is when i transfered the query to
XML. When i did that it kept my entire memo field. I do not want to have in
in XML since my end user really just needs it in excel.



"Gina Whipp" wrote:

Scott,

You say some of the text is cut off... Are you trying to export a Memo
field? How much is some? How are you exporting... TransferSpreadsheet? Do
you have an Export Specification?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"scott04" wrote in message
...
Hi everyone,

I am using access 2003 and am trying to export a report that comes from a
query to excel however some of the text is cut off. I have read others
problems but couldnt find the shoe that fit. Can someone help? Can i
have
some sort of marco that runs my query and then dumps it into excel fully?
If
so please explain. Thanks for your help!

Scott


.