What kind of code could I use to import a table from access to a
worksheet in excel?

I'm thinking of opening the database, opening the table, select all,
copy, and then pasting into my excel file.

Is there an easier way to do this?

The Access table will change on a weekly basis, I want to be able to
reload the new info (into Excel) at the push of a button.

Maybe some kind of office links combo?

Any help is appreciated