need help in setting up import excel file feature in access 2000

[Stuart Taylor]

I've been assigned the task of modifying the company
database. The database, Access 2000, stores its contact
data in two tables (Company and Contacts).

What I need to do is set up some sort of wizard or
automated function so that new staff without great
database expertise can just press a button and automate as
much as possible the following functions:
select an Excel spreadsheet (with a list of company names
in a column and in a 2nd column a number 1 for yes, null
for no)
Import the spreadsheet as a temporary table
when the spreadsheet is imported, it needs to see which
company names have a yes next it, and then attach their
details from both Company and one contact from the Contact
table. It can then delete the ones without a Yes (not
from the Company table though)
Changes made to Contact data in this temporary table
should also affect changes in the Contact table.

I think that's it, but is that even possible? This is way
over my head and I don't know if its in the realms of
reality! :-(

Thanks for any help you can provide.

Stuart