Using Database Query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

david@lewisit.com - 10 Feb 2005 14:33 GMT

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?

Reply to this Message

Carlos Antenna - 10 Feb 2005 17:45 GMT

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

> I'm at a loss as to how to effectively use Excel's
> Database Query function. I can pull in all the records
[quoted text clipped - 13 lines]
>
> Can Excel do this?

Reply to this Message