Use a Column as Excel SQL Paramter

[griffj]

Hi,

Is it possible to use multiple values in a column as parameters for an Excel SQL query?

This is my current SQL statement, but when I try to enter the column as the parameter, it does not accept it.

SELECT Stock_Header.Part_Number, Stock_Header.Description, Stock_Locations.Sold_Last_Year/1000 AS 'Sold_Last_Year', Stock_Locations.Sold_This_Year/1000 AS 'Sold_This_Year'
FROM Dverto.dbo.Stock_Header Stock_Header, Dverto.dbo.Stock_Locations Stock_Locations
WHERE Stock_Header.Part_Number = Stock_Locations.Part_Number AND ((Stock_Locations.Stock_Location='SS') AND (Stock_Header.Part_Number=?))

Any help would be great.

 

[mole999]

pass it as a variable, and loop through
or build an array from the column, and create an array to use as a selection statement

 

[griffj]

Thanks for the response. Could you expand a little on the array. Know how to create an array not sure about the next step.