Import Excel data to MySQL

Last year's investment statistics monthly data volume is large, the original table is the XLS format (or EXECL2003), a single sheet maximum can only put tens of thousands of rows, but the total data has more than 100,000 lines, so can only be stored into two sheet. The EXECL2010 format is a single sheet that can be put down, but it can't actually copy and paste the data from one sheet to another sheet (probably because there are too many rows). Just want to learn the EXECL data into the MySQL database method, and then began to try.

The first use of the MySQL for Execl feature, installed in the MySQL installation of this control, in the Excel Data menu can be directly called, you can follow the data in the first several lines to determine the database type, but the comparison of the chicken, because often not judged, or set the field length is too short, The error occurs when the lead is not complete. Navicate 10 tool to import data.

1, with Navicat 10 open the database to import data 2, click the Import Wizard, select import file Format 3, select the data file to import, if there are multiple workbooks, you can select the Target workbook 4, fill in the imported data rows, date number format 5, select the target table, you can fill in the table name, If the table name does not exist in the database, automatically generate a new table 6, select the generated new table of the field data type, the Target Field name is the first row of the data table. Types support various common types of MySQL (default is varchar, length 255). Note: It is a good idea to check the original Excel data first, if the format of a column has already been defined (as defined as date format), then the corresponding match (also defined as the dates), otherwise the column data will be the wrong number after the import. 7, select the data import Mode 8, press the Start key, import data 9, the export results for the import MySQL data can be exported to Excel file again through the Export Wizard.