NickHK,

I'm trying to do something similar to "monkey harry". An Excel spreadsheet
column contains inventory item numbers that the user types in. The inventory
data is in an Access database. When I use the DataImport External DataNew
Database Query method, I don't see anywhere to set a cell value as an input
parameter. I'm obviously missing a step or something. Any help please?
--
Thanks


"NickHK" wrote:

Look into Dataget External datanew database query, and setting a cell
value as an input parameter.

NickHK

"monkey harry" wrote in message
oups.com...
Can I set a Lookup formula in Excel to read data in an access table
using a macro?

What I'm after is for the user to put in a reference number in a cell
and the clients details to appear in an adjacent cell. I know this is
pretty easy to do completely in Excel but all my data appears in
Access. I do not want to export the Access data into Excel every time
I want to perform this function.

Thanks