Open the ODBC Data Sources Administrator by searching for it in the start menu. With MySQL Connector/ODBC installed, you need to configure the data source in Windows so we can use it in Excel. About Excel showing 32-bit install Step 2: Setup the MySQL Server as an ODBC Data Source You can check your Excel install by going to File > Account and clicking About Excel. In my case, I have a 64-bit system but 32-bit Excel so I actually needed the 32-bit driver. It is important to match the architecture of the driver with the architecture of your Excel install. This is the ODBC driver that will allow you to add a MySQL server as a data source. Step 1: Install MySQL Connector/ODBCįirstly, you must install the MySQL Connector/ODBC software. This tutorial should work on Microsoft Excel 2016 or greater with Microsoft Windows. If you are looking to do the reverse and import an Excel table into any SQL database (including MySQL), try my other tutorial here. In this article, you will learn how to import a MySQL Table from the database into an Excel table using an ODBC Database Query.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |