• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 207
  • Last Modified:

Exporting an Access 2003 Report to excel

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?
0
printmedia
Asked:
printmedia
  • 6
  • 5
1 Solution
 
printmediaAuthor Commented:
also the information I have the report footer does not export.
0
 
rockiroadsCommented:
What command did u use to export to xls?
did u try summat like

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


0
 
printmediaAuthor Commented:
No i go to Tools --> Office Links --> Analyze with Excel
0
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
rockiroadsCommented:
I dont know if there are limitations with that

Can u try in code, just as a test, using the sample code provided
0
 
rockiroadsCommented:
Actually, come to think of it

U cant get a report format layout in Excel can u?
0
 
printmediaAuthor 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.
0
 
rockiroadsCommented:
Have u considered using Snapshots?
0
 
printmediaAuthor Commented:
i've never heard of that. What is that?
0
 
rockiroadsCommented:
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
0
 
printmediaAuthor Commented:
Thanks!
0
 
rockiroadsCommented:
No worries, hopefully Snapshots is something that is a suitable alternative
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now