You should be presented with the Workbook Connections window: The location of the Connections link is circled in red in the above image. The next step is to click on the Connections link located right under the word Data in the tab list. Firstly, you should see something like this: In older versions of Excel, it’s a bit more of a process.
For newer versions of Excel, click on Get Data, then From Other Sources, then From ODBC. Once you have opened Excel, click on the Data ribbon. Now that you have successfully created a new DSN, you can close the ODBC Data Source Administrator window and open Excel. You should now see the data source name you supplied on the form in the previous set listed on the ODBC Data Source Administrator window:
In the future, you can grant additional privileges if necessary.Īfter you have supplied the details for your data source configuration, you should click on the Test button to make sure everything is in working order. For “production” environments, it is suggested you create a new user and grant the new user SELECT privileges only. The MySQL database and table we’re using for this post is on a development machine and is only used by one person. Next you will need to supply the information necessary to complete the form shown above.
You should now see a window similar to the one listed below: To continue creating the DSN, make sure MySQL ODBC 5.x Driver is highlighted and click on the Finish button. If it’s not present, something went wrong with installing the driver in the Preparation section of this post. You will probably have to scroll down to see the MySQL ODBC 5.x Driver. To continue creating the DSN, click on the Add button near the top right corner. DSN file that can be transported to and used on other systems that have the same OS and drivers installed. A System DSN is available to anyone that can log into the machine. A User DSN is only available to the user that created it.
0 kommentar(er)
