Connecting an Excel spreadsheet to an Access database - How to.... ?

[lissa5402]

I keep an excel spreadsheet that lists every form that I receive in my payroll office and mark each entry specifically if they are an employee that has not processed in our office. If I see that they haven't, I go to an Access database/table that someone else in my office maintains with all the names of those who have processed with us.

I would like to find a way to connect the two databases/tables in Excel (I color code a lot of things) to where it will check for those names that I enter into my spreadsheet that also appear in the Access database. This would hopefully allow for a lookup reference or something so that if the name I entered in Excel wasn't in Access, the field would automatically be highlighted or something similar to indicate this information.

Is this possible??

 

[SkipVought]

Hi,

You can use MS Query - Data > Get External Data > New Database query... Select MS Access, drill down to the DB file, and then query whatever tables/queries in Access you wish.

Once you have your data in Excel (I personally use one sheet per resultset) you can query your worn workbook to join your Excel table (sheet) with the resultset table (sheet) from Access. faq68-5829.

This sort of thing is a common occurrent with me, only the external data I go after is in Oracle, DB2, MS Access, Excel & Text files.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}