I'm trying to export a sorted Query into Access via the BE. The query represents data required for a drop-down in Excel. Essentially, the goal is, if records are changed (added or deleted) on the Access side, I want these changes to be exported (pushed) to Excel. So first step is to create a function that will do the export..the next step for me would be to create a refresh button..where a click of refresh would lead to the drop-downs being updated on the Excel side. (so i guess re-query would work here?)
I know there is a newer way to importexport (which appears to be RunSavedImportExport) and the older way (TransferSpreadsheet). I'm just not sure if they are really mutually exclusive in a lot of cases? This is where I would need your expertise.
Regards