-
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
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
|
|