I am creating a Macro, with Transfer.Spreadsheet, Import.
I have entered all the required information, including the path of the Excel file to be imported. When I attempt to execute, I get this message "Operation Must Use an Updateable Query."
1. It does not make sense why thie Macro cannot run stand alone, and why a Query is needed.
2. If a query is definitely needed, please confirm the code/query to be used