Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a database/spreadsheet of information that I need to make a very detailed report from. My knowledge on Access is quite limited so I started doing a mock up of the Report layout in Excel and made this:alt text

So from there, I need the information from the data base to be placed in the properly labeled cells. There are over 2500+ entries in the spreadsheet/database, so if creating a report that looks pretty spot on to the one above in access is doable, that might be an easier route.

share|improve this question
    
admittedly i can not see the image at work (network filtering) but have you tried using Microsoft Word and the Mail Merge feature? –  Xantec Nov 30 '10 at 20:49
    
Do you have a database or a spreadsheet? –  David W. Fenton Dec 1 '10 at 2:51
    
Comment by @kdicus: Have you ever done any database work? I guess, here's what I'm asking -- what is your technical ability with respect to the following: Excel, Access, VBA, ODBC? On a scale from 1 to 10, how would you rate your ability on each of these? –  Ivo Flipse Dec 23 '10 at 10:21

2 Answers 2

up vote 2 down vote accepted

If you want to go straight from database to report, have a look at iReport - which is a bit like Crystal reports without the cost and can connect to Access via ODBC (forum post). Admittedly, this will require some learning and may not be a way you want to go, but iReport is a very flexible tool

share|improve this answer
    
Is it easier to use than the Access report designer? –  David W. Fenton Dec 1 '10 at 2:50

A couple books on the subject you might want to check out:

The former should have plenty of tips on formatting your data and placing it in the proper locations, the latter will give you an introduction to the features of Access you need to get your data into Excel.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.