K kbfalken Nov 22, 2003 #1 I'm wondering if anyone knows if it's possible to use Vlookup and fo the table_array to use an Access Database
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 Nov 22, 2003 #2 No, it is not. VLOOKUP needs an Excel range to look at; it cannot directly access an external database.
No, it is not. VLOOKUP needs an Excel range to look at; it cannot directly access an external database.
P Peo Sjoblom Nov 22, 2003 #3 You could query the database from Excel and get the fields you want and then work on that table in Excel
You could query the database from Excel and get the fields you want and then work on that table in Excel