6.3.2 New Schema Creation in Excel

A schema contains database objects, such as tables, views, and procedures. You can add a new and empty MySQL schema directly from the MySQL for Excel task pane and then export data from your Excel worksheet to the new schema in MySQL.

To add an empty MySQL schema

1. Start Excel, select the Data menu tab, and then click MySQL for Excel to open the MySQL for Excel task pane.

2. From the Open a MySQL Connection area in the task pane, double-click an existing local or remote connection to display the available database schemas.

3. Click Create New Schema to open the New Schema Name dialog (see the figure that follows).

Figure 6.4 MySQL for Excel: Create a New Schema

To create a new schema:

• In the Schema Name field, type the name of the new schema and then select a collation from the list or keep the server default collation.

• When you click OK, the new schema appears in the list of schemas.