SCV/XLS To MySQL Converter? I will pay 50 NP$

[shreder]

Does anyone have a tool/script that converts Excel files or SCV files to MySQL?

I will pay 50NP$ to whoever gives me a script or a link to a free script.

Thank you!

 

[dongan]

Does anyone have a tool/script that converts Excel files or SCV files to MySQL?

I will pay 50NP$ to whoever gives me a script or a link to a free script.

Thank you!

If you have a CSV file, you can strightway, import them into database without any problem.

 

[sacx13]

I think you cannot find a script to export directly to mysql syntax... but you can export in text file and after that to import directly in mysql.

To export in text File use http://bioinformatics.uams.edu/microarray/tools/Excel2text/

If you want to import a csv to mysql try to use :
http://www.stadtaus.com/php_scripts/csv_to_mysql/ueber_das_csv_to_mysql_script.php

Also is very easy to import a csv in mysql diretcly from mysql command line or froma a query shell:
LOAD DATA LOCAL INFILE '/tmp/csv.file' INTO TABLE `table` FIELDS TERMINATED BY ',' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'

Regards

Also is very easy to import a csv in mysql diretcly from mysql command line or froma a query shell:
LOAD DATA LOCAL INFILE '/tmp/csv.file' INTO TABLE `table` FIELDS TERMINATED BY ',' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'

For that csv.file need to be on server.

Regards

 

[Jim_]

mysqlimport --fields-optionally-enclosed-by=""" --fields-terminated-by=, --lines-terminated-by="\r\n" --user=YOUR_USERNAME --password=YOUR_PASSWORD YOUR_DATABASE YOUR_TABLE.csv

Try that command.

or give this script a try: http://codewalkers.com/seecode/448.html