question about using MS Query in Excel

[Gina]

I am exporting many records from an Oracle db into MS Excel. One of the
things I would like to add to this export is the ability for the user to
select a parameter (date range) of the returned data. Is there a way to do
this?

Gina

 

[Héctor Miguel]

hi, Gina !

I am exporting many records from an Oracle db into MS Excel.
One of the things I would like to add to this export is the ability for the user
to select a parameter (date range) of the returned data.
Is there a way to do this?

(i.e.)

Customize a parameter query
Applies to: Microsoft Office Excel 2007
http://office.microsoft.com/en-us/excel/HP102161131033.aspx?pid=CH100648471033

or see a more generic query parameters links:
http://office.microsoft.com/en-us/help/results.aspx?qu=excel+query+parameter&sc=9

hth,
hector.