Exporting to MS Excel

[GS1]

I've got a report that needs to be exported to MS Excel. I have run into a problem where a memo field which views OK in the report is truncated to 127 characters in length by the time it reaches Excel.

Does anyone know how to stop this?

PS I'm using a macro that Uses OUTPUTTO Excel and Autostarts Excel.

Thanks

G

 

[simongallop]

Think that you will find that Access exports to Excel but with the limitations from earlier editions. I have found that even by saying export as Excel97 (manual export) it truncates the output to 16384 rows which is Excel 4 / 5 format. I know that for excel 5 the field length is 255 characters. Perhaps Excel4 is 127? If so that would be the explanation. The work around would be to either try a different format ie rtf or to split the string into 127 character segments and then concatenate them in Excel

HTH