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

shreder · 03-31-2006, 11:53 AM

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 · 03-31-2006, 09:30 PM

Quote:

Originally Posted by 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!

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

sacx13 · 04-01-2006, 04:20 AM

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/micro...ls/Excel2text/

If you want to import a csv to mysql try to use :
http://www.stadtaus.com/php_scripts/...sql_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

Quote:

Originally Posted by sacx13

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_ · 04-01-2006, 07:42 AM

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

03-31-2006, 11:53 AM	#1 (permalink)
shreder NamePros Regular Join Date: Mar 2006 Posts: 779 5.00 NP$ (Donate)	SCV/XLS To MySQL Converter? I will pay 50 NP$ 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! __________________ EKED.COM BDPU.COM FFHF.COM BXNN.COM SFUZ.COM OOHH.NET EOEI.COM NSTO.COM SPMQ.COM CODV.COM - Pm Offers *"What doesn't kill you only makes you stronger..."*

04-01-2006, 07:42 AM	#4 (permalink)
Jim_ NamePros Regular Join Date: Aug 2005 Posts: 585 285.40 NP$ (Donate)	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 __________________ ask me about the internet

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)