Avatar of John Ellis
John Ellis
 asked on

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

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
Microsoft ExcelMicrosoft SQL ServerMicrosoft Office

Avatar of undefined
Last Comment
Wayne Taylor (webtubbs)

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Wayne Taylor (webtubbs)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy