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

Discussion in 'Microsoft Access External Data' started by Chris H, Jan 21, 2004.

  1. Chris H

    Chris H Guest

    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 H, Jan 21, 2004
    #1
    1. Advertisements

  2. 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
     
    Nikos Yannacopoulos, Jan 23, 2004
    #2
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.