We help IT Professionals succeed at work.

Exporting an Access 2003 Report to excel

printmedia
printmedia asked
on
Medium Priority
218 Views
Last Modified: 2008-02-01
Hi all.

I want to export an access report to excel but when I do it does not export the labels.

How can I get the labels do appear in excel?
Comment
Watch Question

Author

Commented:
also the information I have the report footer does not export.
CERTIFIED EXPERT
Top Expert 2006

Commented:
What command did u use to export to xls?
did u try summat like

DoCmd.OutputTo acOutputReport, "ReportName", acFormatXLS, "c:\myrep.xls", True


Author

Commented:
No i go to Tools --> Office Links --> Analyze with Excel
CERTIFIED EXPERT
Top Expert 2006

Commented:
I dont know if there are limitations with that

Can u try in code, just as a test, using the sample code provided
CERTIFIED EXPERT
Top Expert 2006

Commented:
Actually, come to think of it

U cant get a report format layout in Excel can u?

Author

Commented:
Well I got most of the report by using textboxes instead of labels, the only thing that isn't working is the information in the report footer.
CERTIFIED EXPERT
Top Expert 2006

Commented:
Have u considered using Snapshots?

Author

Commented:
i've never heard of that. What is that?
CERTIFIED EXPERT
Top Expert 2006
Commented:
You have heard of PDF, well Microsoft have their own version. It keeps a snapshot of your report (all pages) into its own format and like PDF, u need a viewer to read it

The viewer is a free download,

Access, format is acFormatSNP

e.g.

DoCmd.OutputTo acOutputReport, "MyReport", acFormatSNP, "c:\myrep.snp", True

http://support.microsoft.com/kb/175274

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
Thanks!
CERTIFIED EXPERT
Top Expert 2006

Commented:
No worries, hopefully Snapshots is something that is a suitable alternative
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.