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
Start Excel, select the
menu tab, and then click to open the MySQL for Excel task pane.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.
Click Create New Schema to open the New Schema Name dialog (see the figure that follows).
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
, the new schema appears in the list of schemas.