Solved

Export Access Queries to different sheets in Excel

Posted on 2009-05-12
2
239 Views
Last Modified: 2012-06-21
Hi Experts

The following runs to two separate excel sheets but i'm trying to get the data to run to sheet 1 and then sheet 2 in the same excel workbook.

any help or suggestions is greatly appreciated :)

ozgirl

  DoCmd.OpenForm "PleaseWait", acNormal, "", "", acReadOnly, acNormal
    DoCmd.RepaintObject acForm, "PleaseWait"
    DoCmd.SetWarnings False
    DoCmd.OpenQuery "qryDataDump_Cleanse"
    DoCmd.SetWarnings True
    DoCmd.Close acForm, "PleaseWait"
    DoCmd.OutputTo acTable, "tmpDataDump", "MicrosoftExcelBiff5(*.xls)", "", True, "", 0
    DoCmd.OpenQuery "qryDataDump_Cleanse_Tasks"
    DoCmd.OutputTo acTable, "tmpDataDump_b", "MicrosoftExcelBiff5(*.xls)", "", True, "", 0
    DoCmd.SetWarnings True
    DoCmd.Close acForm, "PleaseWait"
0
Comment
Question by:ozgirl
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 24370606
docmd.transferspreadsheet acexport, acSpreadsheetTypeExcel9,"QueryName1","C:\myExcel.xls",true,"Sheet1"

docmd.transferspreadsheet acexport, acSpreadsheetTypeExcel9,"QueryName2","C:\myExcel.xls",true,"Sheet2"
0
 

Author Closing Comment

by:ozgirl
ID: 31580797
Thanks Heaps  :)
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question