Vlookup to get from MS Access file

[mike31z]

I am new to access and don't if it possible.
I am using win XP SP3 and excel 2000 sp3

In cell A6 I have a 8 digit number and in cell B6 I want to enter a formula to use VLOOKUP to lookup the number in cell A6 and retrieve the data that is in the Access file in the 2d column.

Could someone tell me if this is possible and were can I find a tutorial that can help me learn the basic before I can ask a specific question.

Mike in Wisconsin

 

[SteveO59L]

Data, Import External Data, New Database Query

 

[Andrew Poulsom]

You can't use VLOOKUP, but you can use a parametr query:

http://www.dailydoseofexcel.com/archives/2004/12/13/parameters-in-excel-external-data-queries/

 

[mike31z]

Thanks for the link info have some reading to do.

Mike in Wisconsin