.Cells(3, 1).CopyFromRecordset rs
Yes - I export queries using the Export to Excel macro function and it works better than the transferspreadsheet VBA method. Maybe it's something I was doing wrong, but I couldn't get the VBA method to export the data with lookup values. It only exported the raw data, so all my names/items just had ID values and it was useless. It also keeps adding more sheets to the same Excel workbook each time you run it, so I gave up and stuck with the macro. Something to try.Very simple report might export to Excel nicely but exporting query might be simpler.