Hi,

I thick you cannt add dates using "+".

CONVERT (datetime,departure,1)+ CAST (out_time as datetime) >=Dateadd(mi,-5,GetDate()))

Instead of "+" use dateadd function on right hand side also.

Cheers,

Amol

hi,

This is possible using sp_addlinkedserver. You just need to linked to excel sheet and using DML's or any other SQL command.

You will get exact syntax from follwowing sites;

http://support.microsoft.com/kb/306397/EN-US/