Comparing Data in a worksheet and access.

[Kevin Porter]

I need to open an access database (which only has employee name and store ID)
Compare the name in E1 (then f1, then g1 and so on) see if the name is in
the database, if it matches, then look at the store ID from the database and
write that column into a specific worksheet based on the Store ID.

I have found lots on writing into this or that, but nothing as far as
comparing.

Thanks.