changing parameter in SQL query from Excel

Posted to microsoft.public.excel.programming

Kai[_3_]

external usenet poster

Posts: 3

changing parameter in SQL query from Excel

I am using Excel 2007 and bring data into Excel via an SQL query. How can I
change parameters in the 'Where' clause in Excel without going into the
Connection properties in Excel and changing the parameters in the sql querie
itself?
In the example below I would want to change the DateKey:
SELECT salles
FROM dbo.SalesFact
WHERE (DateKey = 20080524) AND (DateKey <= 20080929)
Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Parameter query in MS Query from Excel	Jimbo	Excel Discussion (Misc queries)	1	September 9th 09 04:27 PM
Excel Query Parameter	Leanne	Excel Discussion (Misc queries)	1	April 23rd 08 08:56 PM
How to choose if I use a parameter or not in a parameter query	Arnaud	Excel Discussion (Misc queries)	0	March 8th 07 01:19 PM
How to put a parameter into an Excel Query	Richard	Excel Discussion (Misc queries)	1	January 6th 06 01:41 PM
How to use a Access Query that as a parameter into Excel database query	Karen Middleton	Excel Discussion (Misc queries)	1	December 13th 04 07:54 PM

All times are GMT +1. The time now is 01:55 PM.

Menu

About Us