Linking Data between Excel and Access

[alistew]

Hi

Is there a way i can link an excel spreadsheet to an access table?

What i have is a table in access with a serialno and product name. I have
an excel worksheet with supplier information and serialno of product. The
common link between the table and worksheet is the serialno. I want to get
the product name from access into my excel spreadsheet.

I tried using Microsoft query but i couldnt get the link between the
serialno in my spreadsheet and serialno in access to work.

thanks