var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Exporting data into different sheets of same excel file
I want to export data from access to excel using following code. My question is how is it possible to export data from two different queries into one excel file which already has got some data in it.
DoCmd.TransferSpreadsheet acExport, 8, "Q_Query1", "C:\New.xls", True, ""
DoCmd.TransferSpreadsheet acExport, 8, "Q_Query2", "C:\New.xls, Ture, ""
Dim XLAddress As String
XLAddress = ("C:\New.xls")
So basically I have an excel file with some data on sheet 1 & 2. I want the data from Query1 and Query2 to be exported in sheet3 and sheet4 of the same file.