Access reporting in excel


Luke Bellamy

Hi - my little access 2002 & recently 2007 application is used mainly by
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

Luke Bellamy

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