Export to Excel - Multiple Worksheets (1 Viewer)

[alexfwalker81]

I have 4 crosstab queries which I can export successfully to .xlsx, using ExportWithFormatting in a macro. However, I'd really like to be able to write the first crosstab to a new workbook, then append the following 3 crosstab queries as subsequent worksheets within the workbook. Is that possible?

 

[Isaac]

One way you can do this is to use Excel automation, combined with the CopyFromRecordset method.

 

[theDBguy]

Hi. Maybe you could also try using the TransferSpreadsheet method.

 

[Uncle Gizmo]

I answered a somewhat similar question recently:-

Make Excel Sheets From Access Table - Nifty Access

Excel Sheets From Access Table OP "avalve" asked this question on Access World Forums:- "Howdy! Let me make a small scenario. Let's say I have a table with fields CarMake/CarModel/Year/Color. What I am trying to do is to export the table to a single Excel Workbook with each CarMake having their...

www.niftyaccess.com

My example uses a query, not a crosstab query but it might give you some ideas.