I have a view in Oracle 11G. I want to show the contents in an Excel 2010 Pivot Table without installing the Oracle Client on my users' machines. So I created a SQL Server 2008 R2 view that queries the Oracle view through a Linked Server. I can run the view in Mgt. Studio. It looks good....I can see the text fields as well as the numeric fields. When I connect to this SQL Server view with the Pivot Table, the numbers disappear.....all zeros! The text fields all look good. I tried to connect with the regular SQL Server Native driver as well as with ODBC and Microsoft Query with the same result. If I connect the Pivot Table directly to Oracle, there is no issue. For whatever reason, this scenario is not yielding results in a Google search. I thought I would check here to see if anyone has seen this before.
It is probably something that Excel should handle. It seems like a UniCode issue, but the source data-type is just Number. I thought there was also a possiblity that the problem could be in my SQL view code or linked-server settings. I included the SQL view code below. I spelled out the fields instead of using *, but it still has the problem.
CREATE VIEW [dbo].[vwIMPACT_FEE_DATA]
AS
SELECT [Applicant]
,[Phone]
,[Address Line 1]
,[Address Line 2]
,[City]
,[State]
,[Zip Code]
,[Premise Address]
......
,[Meter Size]
,[Water Flow]
,[Water Supply]
,[Water System Dev]
,[WW Treatment]
,[WW Collection]
,[Service Line Total]
FROM HANSEN..SAWS.VW_IMPACT_FEE_DATA
GO
Thank you for your help!
Bookmarks