..."tblData", acFormatXLS, "s:\Data".xlsx", , ""
I then tried the old format (which works) but that opens the spreadsheet in Compatibility mode rather than full 2010.
DoCmd.OutputTo acTable, "tblData", "MicrosoftExcel(*.xls)", "s:\Data".xls", , ""
Are there better ways of doing this?
Thanks