Excel mysql connector install#
Excel mysql connector drivers#
Excel mysql connector driver#
Excel mysql connector download#

The configuration order of 1.1 and 1.2 can be arbitrary, but 1.3 must be after 1.2, otherwise the MySQL option cannot be found when adding a new data source to the ODBC data source.

Excel mysql connector drivers#

Open 'Control Panel'-'Administrative Tools'-'ODBC Data Source', in the pop-up window to the right of the 'User DSN' tab, select 'Add', two MySQL drivers will appear in the new database source, respectively For 'MySQL ODBC 5.3 ANSI Driver' and 'MySQL ODBC 5.3 Unicode Driver', it is clear that the difference between the two lies in the encoding standard.

Excel mysql connector driver#

(I tried the 64bit connector installed on a 64bit system, after installation, the connection prompts that the driver cannot be found, and then the 32bit connector is installed successfully) 1.3 Add ODBC data source It should be noted here that when downloading and installing the ODBC connector, choose your The same number of versions of the database, Instead of system bits, otherwise it will still prompt that the database driver cannot be found after installation.

Excel mysql connector download#

Select the operating system and system version, download the corresponding MSI file and install.

Excel mysql connector install#

1.2 Install MySQL ODBC connection service Press Alt+F11 to open VBE, select 'Tools'-'Reference' in the menu bar, in the pop-up reference window, find 'Microsoft ActiveX Data Objects 6.1 Library' and 'Microsoft ActiveX Data Objects Recordset 6.0 Library', put the previous Check the box and click OK. 1.1 Enable script supportД«efore use, you need to start database connection support in VBE. You can choose to use the official installation package, or use the database in the PHP integrated environment. The MySQL service must be installed in the system first, so I won't say much about this. VBA environment configuration before connecting to MySQL In fact, its use is almost identical to MySQL)ДЎ. The integrated database is MariaDB 10.1.13 (If you donвЂ™t understand what MariaDB is, you can think of it as MySQL.

Connect to MySQL database and read and write data in Excel.