RE: Excel Query to i5

["Grizzly Malchow" <grizzlym@xxxxxxxxxxxxxxxxxxxxx>]

I forgot to ask in my previous response. Are you using VBA? My example
would only work if you are using VBA.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Ron Adams
Sent: Wednesday, March 21, 2007 4:22 PM
To: Midrange Systems Technical Discussion
Subject: Excel Query to i5

I have an excel spreadsheet that has a list of part numbers and the user
would like to retrieve the current_cost from the item_master on the i5.
I've tried tried this numerous ways, and while it seems to make the
connection, I can't figure out how to specify on the where clause to
lookup
based on the excel row/column. Is this even possible, and has anybody
else
done it?

Thanks,