Using Database Query

  • Thread starter Thread starter david
  • Start date Start date
D

david

I'm at a loss as to how to effectively use Excel's
Database Query function. I can pull in all the records
for the fields I want but have been unable to figure how
to pull in just the one record I want.

I have a list of part numbers in my spreadsheet and I want to
automatically pull the inventory count for each part number
from an external database.

Say that on the database, column A is the part number and
column B is the qty on hand. What I essentially want to do is
say, "get the value in column B, where column A equals the
value of the spreadsheet cell A1 (where A1 would contain a
part number)". And then repeat that, replacing "A1" with
different cells.

Can Excel do this?
 
I have similar needs from time to time. This is what I do:

Use the database query to pull in the item # and on hand qty. for all items.
Do this on a sheet other than the one you already have populated with the
items of interest.

On your existing page, use the VLOOKUP function to look up the qty from the
query sheet.

Whenever you refresh the query, the quantities will be updated.

-- Carlos
 
Back
Top