Export Access 2010 Report to Excel 2010 (1 Viewer)

Starchildren3317 · Mar 29, 2011

Good Morning community,

I have an access 2003 application that I am trying to convert to access 2010. The one issue that I am running into is exporting a report that I have to an excel sheet.

Here is the code that I currently have in A2003 (NOTE - outReportData is a string containing the name of my report and xlFileName is a string containing the path to the excel file):

Code:

DoCmd.OutputTo acOutputReport, outReportData, acFormatXLS, xlFileName

This works fine in A2003; however, when running it in A2010 I get the following error:

The format in which you are attempting to output the current object is not available.

Any assistance in this would be greatly appreciated!

DiamondKnight19 · Feb 1, 2012

Good morning,

I just ran the following code & it worked without a problem.
Let me know if you see something different.

Code:

Sub Test()

    Dim outReportData As String
    Dim xlFileName As String

    outReportData = "rpt-Cities-Completed-2011"
    xlFileName = "C:\Documents and Settings\haneyr\My Documents\Test.xls"

    DoCmd.OutputTo acOutputReport, outReportData, acFormatXLS, xlFileName

End Sub

Export Access 2010 Report to Excel 2010 (1 Viewer)

Starchildren3317

Registered User.

DiamondKnight19

New member

Similar threads

Users who are viewing this thread