Exporting and linking queries from Access 2K to Excel 2K

  • Thread starter Thread starter Chris H
  • Start date Start date
C

Chris H

I am building a failure analysis tool using Excel 2K as
the frontend for an Access 2K database. Data is entered
into the existing Access database, and will be viewed or
analyzed in Excel. I have approximately thirty queries
built, each of which is to be exported to its own
worksheet.
Questions:
1) Can I export all of the queries en masse, or must they
be done individually?
2) Each query will have three daily updates. How do I link
the queries so that when the data is entered in Access,
our worksheets will also be updated?
 
Chris,

The answer to both questions is basically the same: build in some
automation. You can use either VB code or, if you're not very comfortable
with it, macro(s) to urn the updates and export to Excel.

HTH,
Nikos
 
Back
Top