Chapter 6 MySQL for Excel

Table of Contents

6.1 Introduction

6.2 Installation

6.3 Configuration

6.3.1 MySQL Connections in Excel

6.3.2 New Schema Creation in Excel

6.3.3 Global Options

6.4 What is New in MySQL for Excel

6.4.1 What is New in MySQL for Excel 1.3

6.4.2 What is New in MySQL for Excel 1.2

6.5 Edit MySQL Data in Excel

6.5.1 Edit Session Overview

6.5.2 Multiple Edit Sessions

6.6 Import MySQL Data into Excel

6.6.1 Importing a Procedure

6.6.2 Import — Advanced Options

6.6.3 Adding Summary Fields

6.6.4 Creating PivotTables

6.7 Append Excel Data into MySQL

6.7.1 Column Mappings

6.7.2 Append — Advanced Options

6.8 Export Excel Data into MySQL

6.8.1 Column Options

6.8.2 Export — Advanced Options

6.8.3 Additional Notes

6.9 MySQL for Excel Frequently Asked Questions