Access is a great database, Excel is a great worksheet and sometimes you have to copy or connect information between these applications. There are multiple ways to exchange information between the programs. Helen Feddema goes through them discussing advantages and disadvantages of each approach.
Get Data Between Access / Excel
Pros / Cons Of Each Method
Importing / Exporting
Debugging Strategies
Design Techniques