OutputTo issue

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cat Chowdy - 27 Mar 2008 23:04 GMT

I have been using doCmd.OutputTo acReport, stDocName to send a report to
a file. Using Access2003 this command would give me a list of file types to
select from, txt xls, rtf, html, etc. The same mdb, running in Access2007
on a different computer, is missing the xls file type (along with a few
others). Is this an Access2007 issue? What can I do to get the xls type
back?

Thanks,
Cat

Reply to this Message

Jeanette Cunningham - 27 Mar 2008 23:22 GMT

Cat,
exporting reports from Access to Excel has been disabled in A2007
(microsoft lost a patent lawsuit).
Here are some alternatives:
Export the query that the report is based on.
Export the report as an htm file which can be opened in excel.
Create a temp table, append the data from the query or queries, format and
massage the data then export a query based on the temp table.

Jeanette Cunningham

>I have been using doCmd.OutputTo acReport, stDocName to send a report to
>a file. Using Access2003 this command would give me a list of file types
[quoted text clipped - 5 lines]
> Thanks,
> Cat

Reply to this Message

Cat Chowdy - 28 Mar 2008 14:06 GMT

Wow, hard to believe an MS product can't write to an MS product.

Thanks for the suggestions; the query export will work for the excel output.

Cat

> Cat,
> exporting reports from Access to Excel has been disabled in A2007
[quoted text clipped - 16 lines]
>> Thanks,
>> Cat

Reply to this Message