OLE DB Query in Excel

[JOE OROZCO]

Is it possible to pass parameters to SQL in an OLE DB query within Excel. For example:

Select * from property where prop_id = ?

Somehow link the parameter to a cell in the spreadsheet or something in like. Thanks.

 

[ShaneDevenshire]

Hi Joe,

You can link parameters from your spreadsheet to SQL statements but right
off hand I can't remember if you need to do this with a VBA SQL line or you
can imbed it directly in an SQL statement. Could you show us the SQL
statement or VBA SQL line.