Results 1 to 2 of 2
  1. #1
    Join Date
    May 2009
    Posts
    3

    Unanswered: Exporting Access queries to Excel

    Hi

    Is there any way to export the results of two Crosstab queries into a single Excel Worksheet, specifying destinations for each fields result using VBA?

    I am looking at placing the code in a buttons On_Click event so that the user doesn't have to manually copy the results into the Spreadsheet, therefore eliminating the risk of human error when sending out figures to management.

    I have attached a copy of the Database and the Template Spreadsheet. The queries in the Database to be exported are "7e Completion by Manager Append_Crosstab" & "8f Progress Against Test Plan Append_Crosstab" and a quick look at the Spreadsheet should show where I want the results to go.

    Thanks in advance!!!
    Attached Files Attached Files

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Download this database and run the examples. If any work for you, have a look at the relevant code:
    http://www.dbforums.com/6222281-post4.html
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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