#Power query for office 2011 for mac how to
#Power query for office 2011 for mac mac os x
#Power query for office 2011 for mac install
#Power query for office 2011 for mac drivers

Business users could opt in to a six-monthly update channel. Instead of the old 3-year update cycle, 365 is a constantly evolving product with new features arriving as each new version is released.īecause business users don’t want constant change (and need rock-solid reliable releases) Microsoft introduced the concept of “update channels” for Office 365. Hope this helps you if you’re looking to connect Excel 2011 to query MySQL.Excel 365 is planned to have an infinite life.

If you’ve configured everything correctly, you’ll see the following confirmation dialog.

The test launches a dialog to test the connection, as shown below.Click the Data Source Name and then the Test button. It launches the iODBC Data Source Chooser dialog. At this point, you repeat the Step #1.Click the OK button to complete the configuration. The Data Source Name setup is complete, the next screen lets you launch a connection to the MySQL database.There’s nothing you need do here, but I’d suggest in a real situation that you click the Always include VIEWS in table list check box before you click the Finish button.Click the Preference tab to proceed with the configuration. This step doesn’t initially let you do much but afterward you can set the character set.After entering the data, click the Options tab in the dialog to set the next set of values.

It requires that you’ve configured the database first. The ability to pick the database in the iODBC Data Source Connector is the result of the MySQL Lite tool.

This step requires that you set the user name, password, and database.

After you enter these values, click the Connection tab to the right of the Data Source tab in the dialog box.

The next step requires that you configure the Data Source Name (DSN), provide a hostname and listener port for MySQL (the default port is 3306).

#Power query for office 2011 for mac drivers

Choose one of the OpenLinnk drivers and click the Finish button to continue. It appears that Microsoft Query isn’t a native Intel-port but rather a Power PC port.

#Power query for office 2011 for mac install

If you went to the bother to install the free MySQL Connector/ODBC (instructions here), it won’t work because the Microsoft Component requires Rosetta to work.

#Power query for office 2011 for mac mac os x

The next screen lets you choose a driver from those installed on the Mac OS X system.

You should note that it looks virtually the same as the Windows OS component. It appears that Microsoft didn’t want to provide those components, which are a dependency for Excel 2011, and that’s why you need OpenLink Software, specifically the iODBC Data Source Connector. This type of configuration is provided for by components on the Windows OS (see this post for an example), which don’t exist on Mac OS X.

After the completion, you now configure a Data Source Name.

The install took a minute on my Mac Pro, so I figured you should see the progress bar in case it takes a half minute or so.

Click the Install button to get this working. It will eventually no longer be supported with the release of Lion (at least that’s the rumor at the time of writing).

This first step prompt you to install Rosetta which allows native Power PC applications to run your Intel-based Mac OS X.

It lets you import data from the database. Then, on the Database icon in the Data ribbon. You open a new Workbook and click on the Data tab. I’ve posted instructions in this other blog page because all the screen shots make page loading a problem. The configuration is only required the first time and then you may reuse the connection later.īefore you can begin these steps inside Excel 2011, you need to download and install OpenLink Software’s ODBC Driver. If you need installation instructions for the MySQL database natively on Mac OS X, use this post.

#Power query for office 2011 for mac how to

This blog post shows you how to configure Excel 2011 on Mac OS X to query a MySQL database natively installed on the same Mac.