xls Cell reference in an SQL statement

  • Thread starter Thread starter Gaston WATTIEZ
  • Start date Start date
G

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
 
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.
 
Back
Top