<div>
It is now obsolête.<br>Excel integrate PowerQuery wich is much more versatile.
</div>


<div>
Does it allow me to continue to use SQL without having to know some scripting language?<br><br>Anthony
</div>


Owner

Anthony Mellor

<div>
UGH. No SQL? Sounds like dumbed down drag and drop... I serpose it may be ok.. but the loss of SQL hurts. Maybe that's why the SQL interface is still present, if buried.<br><br>Anthony
</div>


<div>
I used the "drag and drop" term loosely. &nbsp;It is really making selection from the user interface menu.
</div>


<div>
sure, understood, like pivot tables was my assumption
</div>


<div>
For the record Power Query was promised but does not yet work for Mac &nbsp;except by means of VBA .<br><br><a href="https://support.microsoft.com/en-us/office/use-power-query-in-excel-for-mac-7b2f337d-e7d2-4fdf-bf00-3dfbb1e5e9c5?ui=en-US&amp;rs=en-001&amp;ad=US" rel="ugc">https://support.microsoft.com/en-us/office/use-power-query-in-excel-for-mac-7b2f337d-e7d2-4fdf-bf00-3dfbb1e5e9c5?ui=en-US&amp;rs=en-001&amp;ad=US</a><br><br>MS are working on it.<br><br>So we stay with SQL for now, which suits me.<br><br>Anthony
</div>


<div>
<div class="content wysiwyg-content fr-view">
Anyone know if it is still available? Googling it found broken links.<br><br>It still works internally in Excel (for Mac) (with 3rd party paid for ODBC driver), but I can't access any more the diagrams to link tables etc, so limited to only the SQL query text box. <br><br>Anthony
</div>
</div>



Anyone know if it is still available? Googling it found broken links.
It still works internally in Excel (for Mac) (with 3rd party paid for ODBC driver), but I can't access any more the diagrams to link tables etc, so limited to only the SQL query text box.
Anthony

Where has MS Query gone? (The external program, internal is still there)

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.