I am running the following script and it works. The only thing is that it creates a new sheet in the excel workbook rather than over write the existing worksheet. I need it to overwrite what is out there,,,
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, QryName, _
"Z:\Documents\GL\Budget_09\Input_Sheets\Data\IS Budget Exp Sheets_2009.xls", True, QryName & "_payroll_roster"