View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Nick Hodge
 
Posts: n/a
Default 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.