[thelist] How do you edit a query in Excel 2007?

[Rob Smith]

This is more of a free tip than anything else. After grumbling and
mumbling in the new Excel 2007 Beta 2, here's how you edit a query:

1.       Click the properties in the data tab. 

2.       Click the button next to the connection

3.       Switch over to the definition tab

4.       Select the Command type as SQL

5.       Enter the query in the Command Text field.

 

...now if I could only get it to stop crashing!

 


Rob Smith
LexJet
rob.smith at lexjet.com
http://www.lexjet.com
(800)453-9538
(941)330-1210 Int'l
(941)330-1220 Fax
1680 Fruitville Road, 3rd Floor
Sarasota, FL 34236