Similar problem. Exporting from 2022 to Excel. On the wizard I tell it to export to X:\MyFolder\MyFile.XLS but when I select the datasource qryExportThis it gives a destination of 'qryExportThis'. I have to overwrite the destination with the path and name of the Excel file. On the Edit Settings popup screen it comes up with the Create Destination table option only. It is still assuming that I am exporting to a table. It has forgotten about Excel. Roughly translated: it is broken. I cannot (so far) run the DTSX file I have created. I have to do the export manually each time.