I have a query that runs the saved export that exports data to an excel spreadsheet. When I go to run it again, it does not update the spreadsheet with the new data. How do I fix this?
I have a query that runs the saved export that exports data to an excel spreadsheet. When I go to run it again, it does not update the spreadsheet with the new data. How do I fix this?
Suggest you post your code so that we can see what you are doing and perhaps why it is not giving you expected results.
Suggest you post your SQL statement for your query, also if it is not part of your VBA code to export.