Dear Friends,

I have one Linked server AopForecast2005

connected to \\Gaz2k02\AopAndForecast\AOPAndForeCast2005.XLS

srv_product:Jet 4.0
srv_providername:Microsoft.Jet.OLEDB.4.0
srv_providerstring:Excel 8.0

AOPAndForeCast2005.XLS file hase three columns code,Name and forecastvalue on Collection sheet


when i run this query

select * from AopForecast2005...Collection$


everything is fine it returns the data except on column
i.e for Forcastvalue it shows Null even though data is present
over there

Pls solve this problem i have checked all the way to do that


It was working before but suddenly it stoped responding


Sameer786