By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
462,297 Members | 702 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 462,297 IT Pros & Developers. It's quick & easy.

Access 2007 Report Output to Excel

P: 1

I am new to VB and trying to get Excel output from Access 2007-Report
DoCmd.OutputTo acOutputReport, rptName, acFormatXLSX, OFileName, True

I keep on getting:

Run-time error '2282':
The format in which you are attempting to output the current object is not avaialabe.

I would like to go from Report as font and color formattings are completed.

Any suggestions to work around :-)

Oct 25 '07 #1
Share this Question
Share on Google+
2 Replies

P: 1
Microsoft has disabled this feature. Why? I don't know.

Exporting reports to Excel in earlier versions always had little glitches, but most of us either knew ways to avoid those, or were willing to live with it.

Check out this Knowledge Base article

One workaround not mentioned in the MIcrosoft KB article is that you CAN export a FORM to Excel.

Convert your report to a form (a manual copy/paste process), then export the form to excel.
Nov 8 '07 #2

P: 4
how do i do your alternative suggestion in vba

Oct 31 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.