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

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?
 
N

Nikos Yannacopoulos

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
 

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

Top