Access reporting in excel

  • Thread starter Thread starter Luke Bellamy
  • Start date Start date
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
 
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
 
Back
Top