MySQL Forums
Forum List  »  Connector/ODBC

Re: Mysql 8.0.12 for Excel 16.16.2 in Macbook
Posted by: Bogdan Degtyariov
Date: September 18, 2018 04:13AM

Hi Koushik Dutta,

Unfortunately, I don't have the MS Office available for OSX, therefore the steps for setting the ODBC connection up will be general rather then very specific:

1. You need to download and install iODBC driver manager
2. Download and install the MySQL ODBC 8.0 Driver
3. Configure a data source in iODBC configuration dialog.
You will need to put the key-value pairs manually

DRIVER=MySQL ODBC 8.0 UNICODE Driver
SERVER=localhost
USER=<your_user_name>
PASSWORD=<your_password>
DATABASE=<your_database_name>

4. Save the DSN and try testing it using the Test button inside the ODBC Admin.

5. Open Excel and choose importing data from external source where ODBC should be in the list of available options. After that it will display the list of available data sources. Choose the DSN you created.

As I mentioned before, the steps are only the basic ones and you might need to adjust your actions and use the common sense when following them.

Options: ReplyQuote


Subject
Written By
Posted
Re: Mysql 8.0.12 for Excel 16.16.2 in Macbook
September 18, 2018 04:13AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.