changing parameter in SQL query from Excel

Kai

Guest

Posts: n/a

16th Oct 2008

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

« Workbook numbering | auto fill »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Automatic Query Refresh, Changing Parameter	Matthew	Microsoft Excel Crashes	3	14th Apr 2009 07:24 PM
How to use a Access Query that as a parameter into Excel database query	Karen Middleton	Microsoft Access Queries	1	13th Dec 2004 07:54 PM
How to use a Access Query that as a parameter into Excel database query	Karen Middleton	Microsoft Access Reports	1	13th Dec 2004 07:54 PM
How to use a Access Query that as a parameter into Excel database query	Karen Middleton	Microsoft Excel Misc	1	13th Dec 2004 07:54 PM
changing query parameter with an on-click event	nergdergler	Microsoft Access Queries	0	29th Apr 2004 12:38 AM