Results 1 to 3 of 3
  1. #1
    dbDamo is offline Novice
    Windows XP Access 2000
    Join Date
    May 2009
    Posts
    10

    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!!!

  2. #2
    hardtarget is offline Novice
    Windows XP Access 2003
    Join Date
    Sep 2009
    Posts
    3
    Sorry I dont know the answer but you could export the data to excel then run a macro so it completes/makes the table you require?

  3. #3
    dbDamo is offline Novice
    Windows XP Access 2000
    Join Date
    May 2009
    Posts
    10
    Thanks for replying. It turned out that it would have been far too complicated to do what I wanted anyway as the number of rows and columns in the crosstab queries would have changed every time the queries were run, so specifying cell destinations would have been near impossible.

    I ended up exporting the source queries for the crosstab queries and I manually run a macro when the Spreadsheet opens. Not as smooth as I would have liked, but it does the job.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Excel exporting in single cells
    By Paolo29011982 in forum Import/Export Data
    Replies: 0
    Last Post: 07-29-2009, 04:48 AM
  2. Replies: 0
    Last Post: 06-05-2009, 10:47 AM
  3. Exporting a Report to Excel
    By bullwinkle55423 in forum Reports
    Replies: 0
    Last Post: 12-11-2007, 10:27 AM
  4. Exporting a chart to Excel?
    By hraup in forum Access
    Replies: 0
    Last Post: 08-31-2006, 12:21 PM
  5. Exporting from Query to existing Excel wksht
    By kfschaefer in forum Import/Export Data
    Replies: 0
    Last Post: 04-07-2006, 02:46 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums