One more question. I am guessing in the Extended Properties for Provider if i specify "Excel 12.0" both xls and xlsx files will be processed...If i specify "EXCEL 8.0"...

Yes it is, the problem is resolved now.....

Thanks.....that worked.....

I think you are right....I m using bad connection string(as until now we always used to get files in 2003 format)

I will try with ACE 12.0 and will let...

If the users creates excel file using 2007 and save it as xls format, do we need to specify extended properties as Excel 8.0 or Excel 12.0

I am 100 % sure it's getting the right file name.....Now it looks like a different problem

our client submit an excel file every week and it was processing fine until...

Thanks...I tried what u said but when i preview its giving a message Microsoft Jet Database Engine "Invalid Argument"

also just FYI i m trying to save the excel filepath and...

Here is the actual execution plan

Thanks for the details explanation.....

select distinct pid

from table1 det with (nolock)

inner join table2 rate with (nolock) on rate.id = det.SID

where providerid = 2673 and rate.Fyr = '09-10' and (TerminationDate is null)...

both start date, end date and termination date are datetime datatype

select distinct pid

from table1 det with (nolock)

inner join table2 rate with (nolock) on rate.id = det.SID

where providerid = 2673 and rate.Fyr = '09-10' and (TerminationDate...

I tried working in the following way

( @startDate<=TerminationDate and @endDate <= TerminationDate )

(I m passing @startDate and @endDate as parameters)

TerminationDate is DateTime datatype

@startDate and @endDate are DateTime datatype

I know it is not supported....I need to figure out a way to restore the data from production to the development environment

Sorry...my bad, that's a Standard edition