import data with microsoft query
 

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

import data with microsoft query
 

http://nickhodge.co.uk/gui/datamenu/...taexamples.htm

http://www.dicks-clicks.com/excel/Ex...htm#Parameters

--
Regards,
Tom Ogilvy


"PaCoCourt" wrote:

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