Solved

Exporting an Access 2003 Report to excel

Posted on 2006-10-27
11
198 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?
0
Comment
Question by:printmedia
  • 6
  • 5
11 Comments
 

Author Comment

by:printmedia
ID: 17822231
also the information I have the report footer does not export.
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 17822342
What command did u use to export to xls?
did u try summat like

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


0
 

Author Comment

by:printmedia
ID: 17822367
No i go to Tools --> Office Links --> Analyze with Excel
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 65

Expert Comment

by:rockiroads
ID: 17822406
I dont know if there are limitations with that

Can u try in code, just as a test, using the sample code provided
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 17822410
Actually, come to think of it

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

Author Comment

by:printmedia
ID: 17822425
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
 
LVL 65

Expert Comment

by:rockiroads
ID: 17822435
Have u considered using Snapshots?
0
 

Author Comment

by:printmedia
ID: 17822443
i've never heard of that. What is that?
0
 
LVL 65

Accepted Solution

by:
rockiroads earned 500 total points
ID: 17822504
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
 

Author Comment

by:printmedia
ID: 17833541
Thanks!
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 17833914
No worries, hopefully Snapshots is something that is a suitable alternative
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question