Contact MySQL  | 
Login  |  Register
The world's most popular open source database
  • MySQL.com
  • Downloads
  • Documentation
  • Developer Zone
Developer Zone Downloads MySQL.com
Documentation
  • MySQL Server
  • MySQL Enterprise
  • Workbench
  • InnoDB Cluster
  • MySQL NDB Cluster
  • Connectors
  • More
  • MySQL.com
  • Downloads
  • Developer Zone
Section Menu:  
Documentation Home
MySQL for Excel Guide
  • Preface and Legal Notices
  • Introduction
  • Installation
  • Configuration
    • MySQL Connections in Excel
    • New Schema Creation in Excel
    • Global Options
  • Edit MySQL Data in Excel
    • Edit Session Overview
    • Multiple Edit Sessions
  • Import MySQL Data into Excel
    • Importing a Procedure
    • Import — Advanced Options
    • Adding Summary Fields
    • Creating PivotTables
  • Append Excel Data into MySQL
    • Column Mappings
    • Append — Advanced Options
  • Export Excel Data into MySQL
    • Column Options
    • Export — Advanced Options
    • Additional Notes
  • What is New in MySQL for Excel
    • What is New in MySQL for Excel 1.3
    • What is New in MySQL for Excel 1.2
  • MySQL for Excel Frequently Asked Questions
Related Documentation
MySQL for Excel Release Notes
Download this Manual
PDF (US Ltr) - 2.0Mb
PDF (A4) - 2.0Mb
HTML Download (TGZ) - 1.9Mb
HTML Download (Zip) - 1.9Mb


MySQL for Excel

Abstract

This is the MySQL™ for Excel Reference Manual. It documents MySQL for Excel 1.3 through 1.3.8. Much of the documentation also applies to the previous 1.2 series.

For notes detailing the changes in each release, see the MySQL for Excel Release Notes.

For legal information, see the Legal Notices.

For help with using MySQL, please visit the MySQL Forums, where you can discuss your issues with other MySQL users.

Document generated on: 2021-01-23 (revision: 68577)


Table of Contents

Preface and Legal Notices
1 Introduction
2 Installation
3 Configuration
3.1 MySQL Connections in Excel
3.2 New Schema Creation in Excel
3.3 Global Options
4 Edit MySQL Data in Excel
4.1 Edit Session Overview
4.2 Multiple Edit Sessions
5 Import MySQL Data into Excel
5.1 Importing a Procedure
5.2 Import — Advanced Options
5.3 Adding Summary Fields
5.4 Creating PivotTables
6 Append Excel Data into MySQL
6.1 Column Mappings
6.2 Append — Advanced Options
7 Export Excel Data into MySQL
7.1 Column Options
7.2 Export — Advanced Options
7.3 Additional Notes
8 What is New in MySQL for Excel
8.1 What is New in MySQL for Excel 1.3
8.2 What is New in MySQL for Excel 1.2
9 MySQL for Excel Frequently Asked Questions

HOME   NEXT
Related Documentation
MySQL for Excel Release Notes
Download this Manual
PDF (US Ltr) - 2.0Mb
PDF (A4) - 2.0Mb
HTML Download (TGZ) - 1.9Mb
HTML Download (Zip) - 1.9Mb
Contact MySQL Sales
USA/Canada: +1-866-221-0634   (More Countries »)
  © 2021, Oracle Corporation and/or its affiliates

  • Products
  • MySQL Database Service
  • MySQL Enterprise Edition
  • MySQL Standard Edition
  • MySQL Classic Edition
  • MySQL Cluster CGE
  • MySQL Embedded (OEM/ISV)
  • Services
  • Training
  • Certification
  • Consulting
  • Support
  • Downloads
  • MySQL Community Server
  • MySQL NDB Cluster
  • MySQL Shell
  • MySQL Router
  • MySQL Workbench
  • Documentation
  • MySQL Reference Manual
  • MySQL Workbench
  • MySQL NDB Cluster
  • MySQL Connectors
  • Topic Guides
  • About MySQL
  • Contact Us
  • How to Buy
  • Partners
  • Job Opportunities
  • Site Map
  © 2021, Oracle Corporation and/or its affiliates
Legal Policies | Your Privacy Rights | Terms of Use | Trademark Policy | Contributor Agreement |