• Export Query Results to Excel (2000)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Export Query Results to Excel (2000)

    Author
    Topic
    WSSoxRule3530
    AskWoody Lounger
    July 29, 2003 at 9:53 pm #391216

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

    Reply | Quote
    Viewing 2 reply threads
    Author
    Replies
    • WSjohnhutchison
      AskWoody Lounger
      July 29, 2003 at 10:02 pm #697867

      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.

      Reply | Quote
    • WSBat17
      AskWoody Lounger
      July 29, 2003 at 10:39 pm #697896

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

      Peter

      Reply | Quote
    • WBell
      AskWoody_MVP
      July 30, 2003 at 1:06 pm #698078

      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.)

      Reply | Quote
    Viewing 2 reply threads
    Reply To: Export Query Results to Excel (2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    April 2025
    S M T W T F S
     12345
    6789101112
    13141516171819
    20212223242526
    27282930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.