Solved

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

Posted on 2016-09-05
1
65 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

821 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