Export to Excel

[Guest]

I am exporting a query to excel using:

DoCmd.OutputTo acOutputQuery, "QueryName", acFormatXLS, , True

The issue is that one of the fields is a memo field and the data is being
cutoff. There is no order by or group by on the query.

Using Access and Excel 2003

Thanks!

 

[Pepper]

I am exporting a query to excel using:

DoCmd.OutputTo acOutputQuery, "QueryName", acFormatXLS, , True

The issue is that one of the fields is a memo field and the data is being
cutoff. There is no order by or group by on the query.

Using Access and Excel 2003

Thanks!

Just tested this and just for the fun of it, put over 1300 in a cell
in Excel

DoCmd.TransferSpreadsheet acExport, 8, "Table1 Query", "H:
\Office2000\Access\Test2.xls", True, ""

Hope this helps