What I'm trying to do is use Vlookup from Excel to search through data in Access. I'm new to Access, however, and not even sure if this is possible. Eventually, I plan to move beyond Vlookup into more complicated formulas utilizing data in Access but keeping the results in Excel. Is this even possible?

I'm using Excel 2007.

Thanks in advance.