DoCmd.OutputTo - Trunkating strings after 255 characters

J

Jayant Bulbule

I am using DoCmd.OutputTo command to send the output of a report to a
Excel sheet. I am experiencing that long text fields and memo filed
having a data more than 255 characters, get trunkated.

Please let me know what could be the problem or a solution for th
issue?

Thanks in advance,
Jayant
 
K

Ken Snell [MVP]

The OutputTo method for exporting to EXCEL uses an old version of EXCEL
(EXCEL 95, I believe), which was limited to 255-character strings and
16,385(?) rows.

You should use the TransferSpreadsheet action (macro or VBA code) to export
your report's RecordSource to EXCEL. That will avoid these limitations.
 
Top