MS Access Export Query To Excel - Space In Query Name Causing Issues

[Jeffin]

Using underscores is a common way of avoiding problems if something doesn't like object names that contain spaces or start with numbers.

Use OutputTo instead.

DoCmd.OutputTo acOutputQuery, "11 - Rates - Ocean", acFormatXLSX, CurrentProject.Path & "\IL Rate Workbook.xlsx"

Thank you for your reply, this method perfectly maintains the format and name of the query but unfortunately it's limited to one query, each time you use this method the previous query/worksheet get overwritten by the next query/worksheet.

"DoCmd.TransferSpreadsheet" allows me to export all 11 queries to the same workbook as 11 separate worksheets, but it's draw back is the name and format.

Are there any workarounds for the "DoCmb.OutputTo" method so that I can add multiple queries/worksheets to one workbook?

Thank you,

- Jeffin