Hi



I have a spreadsheet with some data in it. I have an Access database with similar data in it.

I want to import the data and then run a series of queries that first of all identifies records in the spreadsheet that do not exist in the database (new recruits), records in the database that do not correspond to any in the spreadsheet (recruits who have now left) and then, finally, to update all records where changes have occured.

It is this last part I am having trouble with. I could run an update query but the fields that require updating are in more than one table and I cannot see how I can do this effectively and accurately.

Is this possible using the query system in Access or should I be doing this in pure SQL?