Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Nov 2001
    Thanked 0 Times in 0 Posts

    Export query data to Excel (Access 2000)

    I've got data in a parameter query that I want to export to an existing Excel file so that I can run a macro on the data in Excel. What is the best way to get my data from the query to the Excel file so that I can run my macro? Would an Excel template work? Do I need to go from Access to Excel? Or should I pull the data from Access to Excel? Please help.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Export query data to Excel (Access 2000)

    To export the results of a parameter query from Access to Excel:

    - Select the parameter query in the database window.
    - Select File | Export...
    - From the Files of Type dropdown list, select Excel 97-2000 (*.xls)
    - Select the Excel workbook.
    - Click Export.
    - You will be prompted for the parameters.
    - The data will be exported to a worksheet in the Excel workbook with the same name as the query. If this worksheet already exists, it will be overwritten by the new data.

    Importing from Access into Excel causes problems for parameter queries.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts