Docmd.OutputTo

[pwils025]

Does anyone know a work around for out putting my access report to excel where my data doesn't get truncated?

This is my code and it cuts off data in one of the cells. The data can be 20 to 500 characters long

sFileName = "c:\" & "rptLicenseeDetailXL.xls" DoCmd.OutputTo acOutputReport, , acFormatXLS, sFileName, True

Any ideas would be great!

Paul

 

[PHV]

Is the DoCmd.TransferSpreadsheet an issue for you ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[pwils025]

Haven't tried TransferSpreadsheet yet, but will it transfer data from a report to the spreadsheet or do I have to pass data from a query?

Benefit of sending from the report is that I have the report setup to filter the records being returned and well as grouping them.

 

[pwils025]

DoCmd.TransferSpreadsheet worked.