• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 212
  • 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
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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