SQL Pivot in Excel 2007 Can't Find Query

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

SQL Server 2005 Forums

Transact-SQL (2005)

SQL Pivot in Excel 2007 Can't Find Query

Author

Topic

PanzerAttack
Yak Posting Veteran

71 Posts

Posted - 2011-07-07 : 07:52:46

I was following these instructions

http://office.microsoft.com/en-in/excel-help/connect-to-import-sql-server-data-HA010217956.aspx

But I can't see my query. Have I done something silly like not Save the Query in the Right Way? I see all the Tables but none of the queries I created.

I can see the queries in Sql 2005 File - Open - File

The Query Type is currently = Select

Do I need to convert this to a View or Something?

PanzerAttack
Yak Posting Veteran

71 Posts

Posted - 2011-07-07 : 08:07:58

Sorry to keep posting and then finding the answers but I really have no idea as to what I'm doing.

I have this one also. My mistake was to create a query. I needed to click on Views (under the list of tables) and select New and create the query there.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources