OpenLink Software
The OpenLink Software provides an ODBC Driver for MySQL 5.x. It’s one of the two options that users have when they want to connect Microsoft Excel 2011 to a MySQL 5.5. The other is Actual Technologies.
The following are the screen shots to install OpenLink Software’s driver on the Mac OS X Snow Leopard. Before you close that page, download the license file that’s shown or Step #8 will be harder than it should be to complete.
- Picking the right version of the OpenLink Software is tricky. You need to follow the instructions carefully at the vendors site. After completing all the input screens, you should get a web page like this:
- The Welcome Dialog confirms that you are installing the correct version of their Universal Data Access Driver Suite. Click the Continue button to proceed with the installation.
- At this stage, you confirm that you have the correct version by reading through the Read Me dialog. What you won’t see clearly is that the OpenLink Software is native to the Power PC not Intel architecture. When you attempt to use the software, Microsoft Excel 2011 will prompt you to install Rosetta Software. Rosetta enables Power PC software to run on Intel-based Mac OS X. It’s amazing that there’s no better alternative but it appears that the Microsoft Query components also require Rosetta but I’ve not done a complete dependency check. Click the Continue button to proceed with the installation.
- This is the license agreement. Click Continue to get the acknowledgment that you read the license agreement.
- Click the Agree button that you read the license to proceed.
- The standard install isn’t small and it includes a driver manager. Click the Install button to proceed.
- The installation prompts for the system administrators password. Enter the Password and click the OK button to install the product.
- The next dialog is a surprise if you closed your browser because you need the trial license that was on the download page. That enabled me to click Use existing License because I’d downloaded it too.
- This step caused me to pause. The MySQL Lite tool is obviously cross-licensed by OpenLink Software and a dependency when working with the MySQL database. Enter your administrator Passord and click the OK button to Install MySQL Lite.
- All things come to an end. You’ve installed OpenLink Software ODBC on your Mac OS X. Now click the Close button to end the installation.
Subscribe via RSS
[…] installed OpenLink Software ODBC Software […]
Excel 2011 to MySQL
26 Feb 11 at 11:15 pm
[…] OpenLink Software’s ODBC Driver […]
Excel 2011 query MySQL
27 Feb 11 at 3:05 am
A few updates, from an OpenLink Software employee…
1. Microsoft has shipped an Intel-native version of Query, as a free update of Office 2011. (This is not available for previous versions of Office.) It’s fully compatible with OS X Lion through Mavericks, and expected to keep working on Yosemite
2. Our drivers are and have been fully Universal (32-bit and 64-bit, Intel and PPC) since each new flavor has been possible. I don’t know why you would think they were PPC-only, unless you were installing an older version for unknown reasons.
3. We have some comprehensive installation, configuration, and testing instructions that may be more accurate than those found on third-party sites, for our Express Edition —
http://wikis.openlinksw.com/UdaWikiWeb/SingleTierExpressPreinstallMac
— and Lite Edition —
http://wikis.openlinksw.com/UdaWikiWeb/SingleTierLitePreinstallMac
TallTed
3 Oct 14 at 1:49 pm
Ted, Thanks.
maclochlainn
4 Oct 14 at 8:57 am
Could you please suggest an example how to INSERT multiple data in Excel Mac to MySQL with VBA? Thanks
Adi
15 Feb 17 at 3:00 pm
Installed OpenLink Software ODBC Software for MySql (5.x) on El Capitain to get Microsoft Excel work with Mariadb (homebrew) installation. A first smoketest does work very well.
jerik
14 Apr 17 at 3:18 pm
I’d suggest you refer to the following MySQL Connector/ODBC Developer Guide.
maclochlainn
27 Oct 18 at 4:35 pm