Thanks, Paul

I have considered that solution, but it is a bit complicated for my
users who would prefer something like a vlookup formula. I have done
some research and it seems that a solution using VBA is the answer....
creating a connection each time the workbook is opened and then
extracting the data from Access with a user defined function.

Has anyone done something similar so that I can get a start with the
code?

On Feb 14, 2:50*pm, "Paul" wrote:
You can do this manually

Experiment with a new sheet, then select DataImport External DataNew
Database Query
and continue from there. *You select a data source and select a table
therein then create a query
and Excel brings the data back.
Use the help files for assistance.
Useful linkhttp://www.dicks-clicks.com/excel/ExternalData.htm

Paul