Display MS Access data in col B when ID# is entered into col A
 

My Excell 2003 spreadsheet records membership fee checks for bank deposit list. I would like to link the spreadsheet to the Access 2003 membership table, so that the "Last Name First" field from Access shows up in col B when I enter the member ID for the check in col A. Thanks for