Restrict Population to MS Query by Cell Ref.

[Lordbean]

Hi,
I'm using ODBC to connect to a data source. MS query tables the record
that, in turn, Excel populates for further manipulation.

I would like to restrict the date range of the data to MS query an
therefore to Excel by specifiying the dates in cells within Excel.

For example: Start date (A1) 01/04/04 End date (A2) 20/04/04

What criteria/formula would have be set in MS query to read the lowe
and upper date ranges in excel cells A1 & A2 sheet 1, prior t
populating sheet 2 with the external data?

Is there a better way perhaps?

Many thanks

bean

 

[Dick Kusleika]

bean

You need two parameters that are based on a cell. See here

http://www.dicks-clicks.com/excel/ExternalData6.htm#Parameters

 

[Lordbean]

Many thanks Dic