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.

Retrieving SQL data into Excel
 

Rob

Try here

http://www.nickhodge.co.uk/gui/datam...taexamples.htm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Rob" wrote in message
...
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.