Problem in retreving data from Linked server

[sameer786]

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

[skhanal]

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

[sameer786]

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.

[skhanal]

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.

[sameer786]

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