Edit an existing query from an outside source from within Excel

[dbwiz]

Arrggh! In Excel 2003, I could create queries using ODBC - point to the database, and save/export those queries back into Excel. I could later select the query from within Excel by going to Data/Import External Data/Import Data, select the query, click open, and then the Import Data pop up that asks you where you want to put the data on the bottom had a button you could click at that point to say Edit Query. It would then open up your editor (I used MSQuery), you could change fields or add/delete tables and when done, you could save it as a new query and import it back into Excel.

OR - you could run the query as it was, then right click on any cell and edit query which would pop up the MSQuery. Quick. Simple.

All I can find to do in Excel 2007 is "refresh." Where, oh kind friends, is the place I need to click or set to do this? I do not wish to recreate the wheel for continually changing reports that run off specific dates, clients, etc.

 

[dbwiz]

Help! Not one person has an answer? Why would Excel 2007 have less functionality/ease of use than 2003? It's supposed to make our lives easier.

 

[chillyok]

So did you ever get an answer? Not sure for v 2007, but it did change in v 2010. On the data tab, click on connections, then the definition tab - at the bottom left of this box, you should find the edit query option. (If you have minor changes, you can also edit these right in the command text box in the definition tab.)

 

[dbwiz]

Thank you! No one responded, but I did finally discover that I could run a query, then right click a cell, but instead of Edit Query from there, had to select Table, and THEN Edit Query. But I appreciate the other update, will definitely utilize that as I have 2010 at home.