Re: MySQL for Excel

[Ryan Alexender]

Open Excel>> Data Menu>> Click My SQL For Excel >>
In My Sql Task pan >>Open a MySQL Connection >>Selsect Schema >> then clilck Next>>Select Cells in excel sheet to export>> Click Export Excel data to new table >>
Select the cells in the Excel worksheet to export and then click Export Excel Data to New Table. A preview window displays the selected data and provides Column Options and Advanced Options to be used during the export operation.

In the Export Data to MySQL dialog, do the following:

Specify whether the first row in the preview should be used as the column name. This option is selected by default.

The First Row Contains Column Names check box controls the data type for columns either by defaulting the type to a suitable one for rows 2-n (if checked) or to one suitable for rows 1-n (if unchecked).

Type a unique table name and select the collation to use for the new table.

Choose or create a primary key column for the new table.

Select each column and apply the appropriate options and option values.

Click Export Data to create the new table with data.