Automate the import of a spreadsheet into Access Database
Posted on 2012-03-27
I'm working on a very simple database that allows me to reduce hundreds of employee salary change records into the most recent for each employee.
Each time we update this query/report, I need to re-import the spreadsheet. Is there a way to automate this such that the user can click a button on a report (or form) that will prompt the user to 'browse' for the spreadsheet. I'd like to automatically use Sheet1 of the selected spreadsheet and place it into T_SalaryHistory, overwriting the current file.
Does anyone know how to do that?