Extracting data from Access in Excel
Could be possible with the use of a UDF, but seems like it could
potentially add quite a bit of overhead. Is it possible for you to
have a hidden sheet that hits your database and refreshes whenever the
workbook is initially opened? Then you could use simple VLOOKUP
formulas to go against that sheet.
Shahid wrote:
Hello,
Wanted to know if there was any way of extracting data from Access by using
a "Vlookup type" function in Excel.
I have IDs in excel but want to enrich that data with information held in
Access..
Is this possible?
|