how to upload excel table to mysql

M

M252015-05-13 01:10:32

MySQL

M25, 2015-05-13 01:10:32

I want to load a table from Excel into a mysql table.
how best to do it?

Reply

Answer the question

In order to leave comments, you need to log in

3 answer(s)

R

restyler, 2015-05-13
@restyler

export from excel to csv, then use sql query with LOAD DATA INFILE

A

Andrew, 2015-05-13
@Ashlst

excel in phpMyAdmin import via csv

M

myfirepukan, 2015-05-13
@myfirepukan

In Excel, File -> Save As, select the CSV format and then parse its values with a script and insert it into the database