LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default How to put a parameter into an Excel Query

This website will explain what you need to know:

http://www.rdg.ac.uk/ITS/info/traini...s/excel/query/

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Richard" wrote:

I am creating an external data query in excel to reterive data from a SQL
database, one of the fields in the db is a date. When I run the query I want
Excel to asked me for a date range for the data to return.

Can any one tell me what I have to enter into the MS Query Editor in the
query criteria area to bring up a window that asks for the start and end date
of the data that it will reterive?

Thanks in advance for any assistance

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Excel Database Query Mark Ansonia Setting up and Configuration of Excel 1 November 4th 05 04:54 PM
AHHH! Again JAA149 Excel Discussion (Misc queries) 0 October 31st 05 11:36 AM
AHHHH-Get Data from Multiple Excel workbooks JAA149 Excel Discussion (Misc queries) 5 October 30th 05 05:19 PM
Wildcard parameter in excel BJC Excel Discussion (Misc queries) 1 December 24th 04 12:16 PM
Excel Query Via Sybase Gary Excel Discussion (Misc queries) 1 December 7th 04 07:58 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"