Problem in retreving data from Linked server

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

Can you try by including column name in select statement?
Are there NULL values in the column in the beginning of the sheet?

I have used the column name in the select as well.but of no use

Yeah in the begining of the sheet null values are there .

it will make any difference

pls let me know.

I think it decides the data type by looking at values in Excel column, if they are null then it may think the whole column is null.

Thanks Mr. Skhanal

I think u r right .when i put 0 in the starting cell of this column

it retrieves the values from this column. otherwise not.

thanks for ur suggestion