Linking worksheet to Access Tables
How can I link a worksheet with an Access Query that combines information
from two of my tables in Access. I use Access to manage my tables and the
information changes daily. When I post the information on my department's
homepage I have to place it in an Excel worksheet. I would like for the
worksheet in Excel to change when ever changes are made to either table in
Access. There is also other worksheet in the workbook on the homepage, if
this matters.
|