<div>
<div class="content wysiwyg-content">
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 
 
&nbsp; DoCmd.OpenForm &quot;PleaseWait&quot;, acNormal, &quot;&quot;, &quot;&quot;, acReadOnly, acNormal 
&nbsp; &nbsp; DoCmd.RepaintObject acForm, &quot;PleaseWait&quot; 
&nbsp; &nbsp; DoCmd.SetWarnings False 
&nbsp; &nbsp; DoCmd.OpenQuery &quot;qryDataDump_Cleanse&quot; 
&nbsp; &nbsp; DoCmd.SetWarnings True 
&nbsp; &nbsp; DoCmd.Close acForm, &quot;PleaseWait&quot; 
&nbsp; &nbsp; DoCmd.OutputTo acTable, &quot;tmpDataDump&quot;, &quot;MicrosoftExcelBiff5(*.xls)&quot;, &quot;&quot;, True, &quot;&quot;, 0 
&nbsp; &nbsp; DoCmd.OpenQuery &quot;qryDataDump_Cleanse_Tasks&quot; 
&nbsp; &nbsp; DoCmd.OutputTo acTable, &quot;tmpDataDump_b&quot;, &quot;MicrosoftExcelBiff5(*.xls)&quot;, &quot;&quot;, True, &quot;&quot;, 0 
&nbsp; &nbsp; DoCmd.SetWarnings True 
&nbsp; &nbsp; DoCmd.Close acForm, &quot;PleaseWait&quot;
</div>
</div>

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"

Export Access Queries to different sheets in Excel

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.