Export to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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!
Click to expand...

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
 
Back
Top