| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
get external data doesn't pull all data
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| updating external data sheet causes loss of data on linked pages | Excel Worksheet Functions | |||
| Pull parameter from worksheet for External Data Query to SQL Datab | Excel Discussion (Misc queries) | |||
| External Data Queries - Data Range Properties v Spreadsheet Format | Excel Discussion (Misc queries) | |||
| pull data for a company with data in diff cells multiple wrkshts | Excel Worksheet Functions | |||
| External Data to be used as in a pull down menu in Excel2003 | Excel Discussion (Misc queries) | |||
Hybrid Mode
