Update Multiple Access Tables Using an Excel Spreadsheet for Update Values
Posted on 2008-06-26
Please note my knowledge level is Beginner...
Is it possible to update multiple tables using an Access Update Query with linked tables and an Excel spreadsheet that contains the 'new' values?
I have one Acesss table called 'Employee' which contains employee_id, employee_name, etc. I have a second Access table called Address, which contains the employee_id, employee'_street, city, and state.
I have an Excel spreadsheet that contains employee name and address changes. Can I link Employee to Address on employee_id and use the update query to update from the Excel spreadsheet all applicable name changes to the Employee table and applicable address changes to the Address table? If this is possible, how would I do this?