Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 link pivot table to sql query results?

Author  Topic 

seanh1016
Starting Member

14 Posts

Posted - 2010-10-10 : 18:42:46
excel 2007
ms sql 2005

can't really find a direct answer on this. need to link pivot table in excel to sql file(query) in ms sql 05. seems like it should be able to be done. not trying to export from sql to excel; just trying to import while in excel from sql. seems like ms office instrucs only direct how to link to a "database and table" in sql, not a specific sql query's results. Is it the same thing?
http://office.microsoft.com/en-in/ex...010217956.aspx


thanks,
Sean

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-11-03 : 09:42:17
Have you tried this?
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -