Hello, I am having a problem exporting to Excel. I have a Memo field that
keeps getting cut off at 255 characters. If I manually run the query, select
File>Export and select Microsoft Excel 97-2002 (*.xls) it SOMETIMES works. Can't seem to figure out why it works sometimes and not other!!!

I would like to create Macro and use the OutpuTo Action. When I select the OutputTo format and then
Microsoft Excel 97-2002 (*.xls), it changes it back to Micosoft Excel (*.xls)
and cuts off the characters. I believe it has to be in the 97-2002 format.
I am using MS Access 2002.

Please help me solve this mystery! Your help is greatly appreciated.