tool that can import excel into mysql?

[Anon]

I'm looking for a tool that can import excel into mysql. And mysql data in an excel file.

Thanks

[[deleted]]

For single sheets, just export them as a tab delimited file, and import them into mysql using the LOAD INFILE command.
Check the manual for syntax.

[Anon]

I believe Vincent meant the command, Load Data Infile. THe syntax for its use is as follows:

LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt'
[REPLACE | IGNORE]
INTO TABLE tbl_name
[FIELDS
[TERMINATED BY '\t']
[[OPTIONALLY] ENCLOSED BY '']
[ESCAPED BY '\' ]
]
[LINES TERMINATED BY '\n']
[IGNORE number LINES]
[(col_name,...)]