Solved

Exporting an Access 2003 Report to excel

Posted on 2006-10-27
11
196 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
Comment Utility
also the information I have the report footer does not export.
0
 
LVL 65

Expert Comment

by:rockiroads
Comment Utility
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
Comment Utility
No i go to Tools --> Office Links --> Analyze with Excel
0
 
LVL 65

Expert Comment

by:rockiroads
Comment Utility
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
Comment Utility
Actually, come to think of it

U cant get a report format layout in Excel can u?
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

Author Comment

by:printmedia
Comment Utility
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
Comment Utility
Have u considered using Snapshots?
0
 

Author Comment

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

Accepted Solution

by:
rockiroads earned 500 total points
Comment Utility
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
Comment Utility
Thanks!
0
 
LVL 65

Expert Comment

by:rockiroads
Comment Utility
No worries, hopefully Snapshots is something that is a suitable alternative
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

771 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now