Export to Excel

A

Anonymous

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!
 
P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top