rrtraverse
asked on
Update Multiple Access Tables Using an Excel Spreadsheet for Update Values
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?
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?
Hello rrtraverse,
I'm with Ray. The only reason you'd need a separate address table is if you wanted to be able to track
multiple addresses for a given employee (work address and home address, say) or if you wanted to
store the addresses on an effective-date basis.
Regards,
Patrick
I'm with Ray. The only reason you'd need a separate address table is if you wanted to be able to track
multiple addresses for a given employee (work address and home address, say) or if you wanted to
store the addresses on an effective-date basis.
Regards,
Patrick
ASKER
It was just an example to show what I was trying to do
If you link to an Excel spreadsheet which contains both Name and Address data, you can use the linked table to replace/append the data in both your Employees and Addresses tables. Are we to assume the Excel table is a master list of names and addresses or does it contain only 'added' data? That would dictate whether one used it in a SELECT INTO query or an INSERT query.
ASKER
The Excel spreadsheet will contain data changes
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
My question, which was obviously stated badly was whether or not you could update more than one table at a time. Since your most recent response instructs me to update one table, and then the other, I will assume this means you can update only one table at a time.
Thank You
Thank You
Thanks, but why the B? If it were possible in a single query, of course I would have shown you that. I saw 'Beginner' and went through considerable detail on creating and executing the queries. Needless to say, I can hardly wait for the next question...
Employees
========
EmpID
FName
LName
Add1
Add2
City
State
Zip
Phone
etc.
If John and Martha Smith both work for you at the same address and phone number, you distinguish them by the EmpID - nothing else.