Sharing Access Data with Excel

[share_knowledge]

Currently, i have a set of data, which resides in Access as a table. This table contains two columns as follow:

Item -- Price
1------- $5
2------- $6
3------- $7
4------- $8
5------- $9

In addition i have a spreadsheet with the item number on one column as follow:

Item-- Price
1
2
3
4
5

Is there a function within Excel that match the item number from the spreadsheet against the table in Access then return the price data to the Excel spreadsheet?

Example:

=VLOOKUP(Excel_Item, Access_Table, Access_Price , 0)

i'm not sure how to incorporate the access table in Excel. Hopefully this make sense. Thanks in advance for your help!

 

[Andrew Fergus]

I can't answer your question directly but what is that you are trying to do in Excel that you cannot do in Access? In other words, why the need for the Excel spreadsheet?
Andrew