Code to get the results of two different queries in access in to one sheet in an xls

[mkc80]

Can someone please provide me with the code to export the result of two different queries in access in to just one sheet in an Excel WorkBook?
Like for example if I have two columns from query-1 and two columns from query-2, I want the result in say from cells A2:B100 and then D2:E100.

And also may be provide a header (label) on top of both of the results in Excel Sheet?

I am a newbie, so would need detailed instructions is possible. Thanks!

[June7]

Can those two queries by joined in another query?

You want an additional header row above the 4 columns? The export wizard or TransferSpreadsheet method could not do that. Would need VBA code to modify the spreadsheet.

Review this thread discussing methods of exporting to Excel http://forums.aspfree.com/microsoft-...el-413629.html

And about modifying the Excel worksheet https://www.accessforums.net/showthr...c-Excel-format

[mkc80]

Yes you are right...Thank you for the links..