Access reporting in excel

L

Luke Bellamy

Hi - my little access 2002 & recently 2007 application is used mainly by
accountants.
I have lots of pretty reports and can export these to excel.

Being accountants they want to do reporting in excel but they also want to
be able
to create their own reports. The only way I can think of doing this easily
is to link the
mdb tables into Excel and then write some interface/functions to make this
user friendly.

Anyone know of any free or commercial fancy Excel front-end to an access
database?

Thankyou,
Luke Bellamy
 
J

Jeff C

Use your Access data tables as external data sources to excel - when the data
in Access changes - refresh the data in Excel and proceed -

Data - Pivot tables - external datasource etc
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

giving a presentation on why accountants should learn someaccess...is what i say fairly accurate? 1
Access 2007 Data Dictionary Reporting Tool 5
Can I edit macro buttons on the quick access toolbar in excel? 0
Cool reporting 5
Access 2007 Reporting Versus Crystal Reports 2
exporting report fields to spreadsheet 1
"Open in Excel" vs "Open in Excel Online" 1
reporting excel vs access 3

Top