| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Lost in Microsoft Query | Excel Worksheet Functions | |||
| Variable external data through a Microsoft Query | Excel Worksheet Functions | |||
| Microsoft Query: retrieve data by dates | Excel Programming | |||
| How do I import data from Microsoft Project 2003 to Excel? | Excel Discussion (Misc queries) | |||
| Using Microsoft Query to Extract Data | Excel Programming | |||
Linear Mode
