Vlookup - using a database as the table_array

K

kbfalken

I'm wondering if anyone knows if it's possible to use Vlookup and fo
the table_array to use an Access Database
 
V

Vasant Nanavati

No, it is not. VLOOKUP needs an Excel range to look at; it cannot directly
access an external database.
 
P

Peo Sjoblom

You could query the database from Excel and get the fields you want and then
work on that table in Excel
 
Top