MySQL Forums
Forum List  »  MySQL for Excel

Re: MySQL for Excel
Posted by: Ryan Alexender
Date: July 31, 2017 12:01AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
190
July 28, 2017 10:38PM
Re: MySQL for Excel
104
July 31, 2017 12:01AM
95
July 31, 2017 01:53AM
69
August 07, 2017 09:29AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.