xls Cell reference in an SQL statement

[Gaston WATTIEZ]

I want to make a reference of a cell within an SQL
statement.

e.g.
Select * from table
when table.fields = Sheet1!A1

Could you give me a correct example of statement ?

Thank a lot in advance,
Gaston

 

[Dick Kusleika]

Gaston

Are you using Data - Get External Data to make a QueryTable? If so, open
the query in MSQuery and add a criteria. Something like [Enter criteria].
The [] make it a prompt. Then, in Excel, the Parameters button the External
Data Toolbar will be enabled and you can change from a prompt to a cell on
the sheet.