I am using the following code to export an Access query to Excel:
Set sht = wbk.Sheets.Add
sht.Name = "Cost Data"
Set rs = CurrentDb.OpenRecordset("sqryExportToAdmin_CostDetails", , dbFailOnError)
I would like the heading of the query to appear on row 1, is there a parameter I can turn on to include field headings?