VLookup from Access into Excel

[dmposey61]

Forgive me for duplicating this, but I replied to my own thread. I am needing help with the following: See post on 4/14/04 (Posted 3/27/2004.

I want to use the VLookup function in Excel to pull data from an Access database. I am using Excel 2000 in XP.

Thank you!

 

[ETID]

look in the help for the sql.request() function,

this should do what you want.