-
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?
-
Retrieving data problem
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|