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. 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.
