Solved

Microsoft Query for Excel 2010:  Making the "Command text" Box Bigger

Posted on 2016-09-05
1
52 Views
Last Modified: 2016-09-06
Hello:

After using the Microsoft Query wizard for Excel 2010 (32-bit), you are always able to click the Data menu selection, choose "Connections...Properties", and click the Definition tab.

In that tab is the "Command text" box, where you can enter a T-SQL "select" query.

I know that this is a strange question.  But, is there any way of making that box bigger?  

If so, it would make it so much easier to experiment with typing T-SQL "select" queries.  And, it would save the end user the trouble of having to go back and forth to the SQL Server Management Studio query editor to test queries.

Thank you.

John
0
Comment
Question by:John Ellis
1 Comment
 
LVL 47

Accepted Solution

by:
Wayne Taylor (webtubbs) earned 500 total points
ID: 41785382
Hi John,

The entire dialog box is resizable, which also resizes the Command Text box. Grab the bottom right corner and resize as required.
Untitled.png
Wayne
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
My experience with Windows 10 over a one year period and suggestions for smooth operation
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now