Hello,
I'd like to retreive data from an external database in excel. To import
those datas, a criteria (a number) is used. So, there are :
1.an ODBC link (Teradata) to a database.
2.an SQL query (external data import - new query).

Excel import the external datas but criteria is coded in the query :
-- extract of the query -----
SELECT DISTINCT ... WHERE .... AND (Task.opportunity_id = '552768' )
-------------------------------
Now, i'd like to replace '552768' by a value find in a cell or asked via the
query (for instance 'input').

Could you help me ?
Tks
Pascal