Solved

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

Posted on 2016-09-05
1
71 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

To Patch or not to Patch? That is the question!

Don't get caught out like thousands of others around the world in the recent Ransomware Fiasco!
Discuss..
- Why it's not a good idea to wait before Patching
- Sensible approaches to Patching discussed
- Add your feedback, comments and suggestions

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

739 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