Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jul 2003
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Export Query Results to Excel (2000)

    I want to export the results of a query to a Microsoft Excel spreadsheet. How? Thanks for any help.

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Export Query Results to Excel (2000)

    With the results of the query on the screen, go to Tools...Office Links...Analyse with Excel.

    This assumes you want to do it yourself. Alternatively you can programme it to happen automatically.
    Regards
    John



  3. #3
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Export Query Results to Excel (2000)

    With the query open you can just copy all the data and paste it straight into Excel.

    Peter

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Export Query Results to Excel (2000)

    And another way - simply right-click on the query you want to export, and choose the export option. You will be prompted to select the kind of file you want to create, and Excel is one of the choices. (Of course you can also do it with code, using either the TransferSpreadSheet command, or using Automation.)
    Wendell

Posting Permissions

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