Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Connection to external data sources in Excel
I created a worksheet in which I am pulling data from SQL 2005 via stored
procedure (with worksheet level connection string and trusted connection). In the 'Connection Properties' I am specifying the connection string and the name of the stored procedure. I can go and click on the data region (table that was retured by the call to the Sql), then on the 'Data' table -'Connection Properties' (which is enabled if the Excel has defined connection information). Everything is working fine and as expected. However, I have noticed on several occasions that sometimes Excel 2007 is "dropping" the connection information (and connection string itself) disabling the 'Connection Properties' under 'Data' tab. So in order to recreate the data pull I have to start from scratch (Define connection string, etc). I am not an Excel wiz, so I could be doing something wrong here. Any ideas greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing External data from various sources | Excel Discussion (Misc queries) | |||
help on pivot tables using external data sources | Excel Discussion (Misc queries) | |||
Why can't I edit my external data sources? | Links and Linking in Excel | |||
Why can't I edit my external data sources? | Links and Linking in Excel | |||
Why can't I edit my external data sources? | Excel Discussion (Misc queries) |