How do you use MS Query in MS Excel 2010?

MS Query is used to import data into a MS Excel application (Work sheet) in Microsoft Excel. Here Microsoft Excel in the Microsoft Office Professional Plus 2013 (x32bit)  suite is used.

Using Microsoft Query data from a table in SQL Server 2012 can be imported into an excel sheet. The process is explained in great detail here:

http://hodentekmsss.blogspot.com/2014/07/how-do-you-import-data-from-sql-server.html

In order to carry out the steps in the above, you must first create an ODBC connection to SQL Server (in this case SQL Server 2012 Express) will be required. If you do not have a DSN made follow this link to learn how:

http://hodentekmsss.blogspot.com/2013/08/how-do-you-create-odbc-dsn-to-sql.html

 

What is the difference between MS Query and Power Query?

As the name suggests Power Query is more powerful than MS Query. MS Query handles only ODBC data sources but Power Query can handle lot more.

Some details here:
http://hodentek.blogspot.com/2013/12/what-is-microsoft-power-query.html

Both MS Query and Power Query can be accessed in Microsoft EXCEL.

MS Query and Power Query in MS EXCEL 2010 Professional Plus and x32 bit

You have to install the EXCEL add-in for POWER Query from here:
http://www.microsoft.com/en-us/download/details.aspx?id=39379


Here is the ribbon tab for Power Query: