To import data from excel to mysql database [duplicate]

This question already has answers here: Closed 11 years ago.

Possible Duplicate:

how to import from MS excel into MYSQL DB

I wish to import some data from excel to mysql database. my query is

LOAD DATA LOCAL INFILE 'd:/Book1.csv' INTO TABLE exp FIELDS TERMINATED BY开发者_StackOverflow ',' LINES TERMINATED BY '\n';

I receive an error File 'd:/Book1.csv' not found. Is there anything i want to do.

---

There is a good tool for this called RazorSQL.

That's what I use to import data to my database, I'm not sure if it supports a mysql database, but I think it does.

Well, this is a good way to do it if you don't want to do it at runtime with code.

Tjekkles