How to convert a report to an excel spreadsheet?

V

vanessa

I'm trying to convert an access report to an excel
spreadsheet but is just doesn't work.

I'm using the outputto method:

DoCmd.OutputTo acOutputReport, "myreport",
acFormatXLS, "\\myserver\myreport.xls", False, ""

I'm always getting the following error message:

Microsft can't save the output data to the file you've
selected.
When I'm doing this manually it seems to work fine.
Any help is most appreciated!!
 

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

Similar Threads

Export report to Excel, Error message "Compile Error: Argument not 0
Some of the sum totals are exporting to Excel 0
Need Help with a VBA subroutine 0
Export to Exel using Access 2000 and 2007 1
the OutputTo Action Was Cancelled, runtime error 2501 1
output to, transferspreadsheet, or excel automation? 2
Export Report with Graph to Excel error 2495 1
DoCmd.OutputTo Crashes Access 2007 0

Top