Excel External Data Selective Import.
 

Hi All

This is my 1st post.

I have access to a MS SQL database and tables and views within. I
currently pull data into the spreadsheey via the external data option
within excel. I would like to expand on this and pull less data rather
than delete what I do not need.

There is a field in the database data called ts_start_date. I wish to
be able to put 2 date values in 2 excel cells and use these to filter
the data returned.

Exmaples.

A1 Has the date 02/09/2006 08:30 and B1 has the date 10/9/2006 17:30.

The returned date would only have dates in the field ts_start_date with
dates and times within this A1 B! range.

Please how do I easily do this. I can do this in raw SQL but I need to
make this excel easy for my basic users.

Thanks Martin