MySQL for Excel is a product for Microsoft Windows, and it is installed with MySQL Installer. And typically you will not be required to install or configure additional tools to use MySQL for Excel.
The MySQL Installer installation process will check if these requirements are met, or notify you if further action is required before proceeding with the installation.
.NET Framework 4.0 (Client or Full Profile).
Microsoft Office Excel 2007 or greater, for Microsoft Windows.
Visual Studio Tools for Office 4.0, and MySQL Installer may install this for you.
An available MySQL Server connection.
MySQL for Excel is loaded and executed by selecting the Data menu tab in Excel, and then choosing the "MySQL for Excel" Database icon. This opens a new Excel sidebar with the available MySQL for Excel options. The navigation bar with the MySQL for Excel icon is shown in the following screenshot:
While each action, such as Import MySQL Data, has its own set of options, this section describes the global options that affect the entire plugin.
Wait [ ] seconds for a connection to the server before timing out. Defaults to 15.
Wait [ ] seconds for a database query to execute before timing out. Defaults to 60.
SQL Queries Options:
[ ] Use optimistic updates on all Edit Data sessions. Enabled by default.
( ) Do not show SQL statements sent to the server. Enabled by default.
( ) Preview SQL statements before they are sent to the server. Disabled by default.
( ) Show executed SQL statements along with their results. Disabled by default.
Edit Session Options:
[ ] Restore saved Edit sessions when opening an Excel workbook. Enabled by default.
( ) Reuse Excel worksheets matching their names with the session table names. Enabled by default.
( ) Create new Excel worksheets for the restored Edit sessions. Disabled by default.
Copyright © 1997, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices