mapping excel data to mysql database

Question

how to mapping excel data column name to mysql data field? and mapping between excel data column name and mysql data field name and getting the excel data from excel file

Answer 1

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";`

Answer 2

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

Answer 3

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