?
Solved

Exporting reports to Excel

Posted on 2001-07-17
11
Medium Priority
?
225 Views
Last Modified: 2012-08-14
i am trying to get some reports with limited grouping to export to Excel and look good...Any tips?  My grouping tends to look ugly and the headings are all messed up....Anyone out there an expert at making an Access report export to excel and still look good?

Thanks in advance...
0
Comment
Question by:svfafel
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +4
11 Comments
 
LVL 3

Expert Comment

by:tdaoud
ID: 6290815

I can suggest that you try first to Word then import from Word, it might look better.

Good Luck,

Tarik
0
 
LVL 6

Expert Comment

by:PsychoDazey
ID: 6290934
My work-around in the past has been to export the reportto my file.  In my file I have a macro that runs on open and does my formatting for me.  There are articles on Microsoft.com that deal with exporting reports if you are seeking further info.
0
 

Author Comment

by:svfafel
ID: 6290956
Psycho, any links to microsoft articles?
0
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 

Expert Comment

by:bshepherd
ID: 6290957
Forget Excel....Save as/export as .RTF, and open in Word the only formating you will lose is lines. It looks great.  
0
 
LVL 6

Expert Comment

by:PsychoDazey
ID: 6291028
I have had problems exporting to RTF as well.  Let me look for the article svfafel.
0
 

Author Comment

by:svfafel
ID: 6291034
much appreciated...
0
 
LVL 8

Expert Comment

by:dovholuk
ID: 6291088
the key is to not use group headers or footers. what you need to do is put ALL your controls on the detail screen and then run your report.

it's a lot harder to get the desired effect, but when you export you won't get ton's of "goofiness" that can happen.

basically all you can do is fiddle. export. fiddle. export. fiddle. export etc. until you get the desired output.

enjoy.

dovholuk
0
 

Expert Comment

by:amp072397
ID: 6744837
Another one, svfafel.

This is a free technical support site.

Experts who answer questions here receive no pay or other compensation except Expert points as a result answering questions and being awarded points.

As a result, and as a Moderator of this forum, my goal is to ensure that Experts and Askers alike no longer allow questions to get stale.

Please provide that feeback now. It's greatly appreciated!

If you need any help at all in cleaning up this or any other questions, don't hesitate to contact me via email. I will assist in any way that I can.

thanks
amp
community support moderator
amp@experts-exchange.com
0
 

Expert Comment

by:amp072397
ID: 6783394
svfafel:

You have many open questions:

http://www.experts-exchange.com/jsp/qShow.jsp?qid=20151411
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20142486
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20152290
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20153618
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20155682
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20169125
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20175800
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20180978
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20190767
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20169126
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20146852
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20128521
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20134835
http://www.experts-exchange.com/jsp/qShow.jsp?qid=20136451

To assist you in your cleanup, I'm providing the following guidelines:

1.  Stay active in your questions and provide feedback whenever possible. Likewise, when feedback has not been provided by the experts, commenting again makes them receive an email notification, and they may provide you with further information. Experts have no other method of searching for questions in which they have commented, except manually.

2.  Award points by hitting the Accept Comment As Answer button located above and to the left of that expert's comment.

3.  When grading, be sure to read:
http://www.experts-exchange.com/jsp/cmtyQuestAnswer.jsp#3
to ensure that you understand the grading system here at EE. If you grade less than an A, you must explain why.

4.  Questions that were not helpful to you should be PAQ'd (stored in the database for their valuable content?even if not valuable to you) or deleted. To PAQ or delete a question, you must first post your intent in that question to make the experts aware. Then, if no experts object after three full days, you can post a zero-point question at community support to request deletion or PAQ. Please include the link(s) to the question(s).
CS:  http://www.experts-exchange.com/jsp/qList.jsp?ta=commspt
At that point, a moderator can refund your points and PAQ or delete the question for you. The delete button does not work.

5.  If you fail to respond to this cleanup request, I must report you to the Community Support Administrator for further action.

Our intent is to get the questions cleaned up, and not to embarrass or shame anyone. If you have any questions or need further assistance at all, feel free to ask me in this question or post a zero-point question at CS. We are very happy to help you in this task!


thanks!
amp
community support moderator

2/6
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
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…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Suggested Courses

752 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