To import data from excel to mysql database

Question

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 ',' LINES TERMINATED BY '\n';

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

Answer 1

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