mapping excel data to mysql database

how to mapping excel data column name to mysql data field? and mapping between excel data column name and mysql data field name and开发者_Python百科 getting the excel data from excel file

use LOAD DATA INFILE with a delimited text file (save the Excel as .txt). You choose exactly which columns map to which fields.

Here's the method I use for getting data from Excel to MySQL: Excel to MySQL using Add-ins

save your excel file as csv and type the query load local data infile "your file path" into your table name fields terminated by "," lines terminated by "\n";`