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

--
Message posted from http://www.ExcelForum.com