import data with microsoft query

P

PaCoCourt

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dumb question alert! What program to use? 0
Access Query to import from Sharepoint 0
query external database 5
Ms query and Excel 0
Link, drop link, relink 2
delete external data query 1
Excel Import External Data Wizard 3
import external data as a List (not table) into excel 2010 with excel 2000-2003 list format 0

Top