Retrieving SQL data into Excel

Hi,

While I can retrieve data from a SQL Server into Excel successfully, I'd
like to filter the data by specifying a criteria where the date column from
the SQL Server database is greater than or equal to the current date.

I have tried using the TODAY() Excel function but to no avail. Has anyone
else tried this? Your comments, help, and suggestions are highly appreciated.
TIA.

Regards,

- Rob.

Rob

Try here

http://www.nickhodge.co.uk/gui/data...ataexamples.htm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"Rob" <Rob@discussions.microsoft.com> wrote in message
news:E9A00B61-289B-4FCC-B037-02B63CA1EE91@microsoft.com...
> Hi,
>
> While I can retrieve data from a SQL Server into Excel successfully, I'd
> like to filter the data by specifying a criteria where the date column
> from
> the SQL Server database is greater than or equal to the current date.
>
> I have tried using the TODAY() Excel function but to no avail. Has anyone
> else tried this? Your comments, help, and suggestions are highly
> appreciated.
> TIA.
>
> Regards,
>
> - Rob.