Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2004
    Posts
    41

    Question Unanswered: Exporting multiple Access queries into one Excel Workbook

    Is it possible to export multiple MSAccess queries into one MSExcel workbook?
    Thanks,
    Reg

    Now that I've been told it's possible, does anyone know how??
    Thanks, Reg
    Last edited by Reg; 12-12-04 at 12:02.

  2. #2
    Join Date
    Sep 2004
    Location
    Charlotte, NC
    Posts
    164
    Yes you can. They will show as separate worksheets within the Excel file.

    TD

  3. #3
    Join Date
    Dec 2004
    Posts
    41

    Question Multiple Queries to One Excel File

    Great! Could anyone tell me how?

  4. #4
    Join Date
    Sep 2004
    Location
    Charlotte, NC
    Posts
    164
    You can do it by running your query and then choose File|Export and selecting Excel as the File Type and then entering a Spreadsheet name. Then run the next query and do the same thing, except choose the same file you just saved the last one into.

    If you want to do it with a Macro, create a new Macro and use TransferSpreadsheet and select Export, enter the query you want to export and enter the full path and file name that you want the data exported to. On the next line do the same thing but change the name of the query you are exporting from. Save the macro and run it.

    TD

  5. #5
    Join Date
    Dec 2004
    Posts
    41

    Thumbs up Worked!

    buckeye_td,
    Thank you very much for the information - works like a champ!

    Cheers,
    Reg

  6. #6
    Join Date
    Apr 2014
    Posts
    1

    Thanks you guys

    Hello

    I found this post on google. While it didn't help solve my problem, I'm really glad that you in the dbforums community are here to answer these sorts of questions

    Thanks a lot everyone

    http://www.dbforums.com/db_images_v3...ilies/beer.gif

    Cheers,

    Mr. Orbitman

Posting Permissions

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