external data doesn't show all data...

Giganews Newsgroups
Subject: external data doesn't show all data...
Posted by:  Melissa Ragsdale
Date: Mon, 7 Jul 2008

I am trying to access a SQL database (MS CRM 4.0) using the Connections
feature in Excel 2007.  I am able to connect to various tables and views,
however, some key columns of data do not appear.  I am wondering if they are
hidden or I have a security issue.  If I try to access the data using SQL
Server BI 2005, all data is available.  However using Excel 2007, the columns
I need to connect the data to other tables is missing.  Any thoughts?

Replies