Access Reports from Excel

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Is there a way to put a link to an access report
into an excel spreadsheet? In other words, create
a "button" or whatever on a worksheet that links
over to an existing report in Access, and when
the link is used it causes the report to run and
appear on the spreadsheet?
 
I don't about linking to an actual report, but Excel can
easily link to existing Tables and Queries that you have
already setup in Access.

Go to Data -> Import External Data and choose the Access
tables you want to get. The interface is very similar to
an Access Query, and you can "pretty-up" the information
once you get it into Excel.

I do it all the time, and it works like a charm!

HTH

Eric
 
Back
Top