Background: Every day we must refresh/update or overwrite Access tables with new data incoming on Excel spreadsheets. For the most part, I'm using the Saved import/Export procedures built into Access and executing them with VBA code. I don't know if this is the best way to bring in data from Excel but it's all I know.
Question: When I run a saved import procedure from an Access front end, a table is created in the front end instead of the backend. Why doesn't the table refresh in the back-end instead? Would someone pleasel ook at my code (attached).