Page 1 of 1
EXCEL -> MYSQL
Posted: Fri Feb 13, 2004 5:46 am
by Citizen99
I need help with converting data from excel to mysql, (xls -> csv -> mysql). Maybe someone could help me ? THX.
Posted: Fri Feb 13, 2004 12:01 pm
by McGruff
Once you've created a csv file, you can use the db manager phpMyadmin to import to mysql.
If you want to write your own script, check out LOAD DATA INFILE in the mysql manual.
Posted: Sat Feb 14, 2004 3:00 am
by Citizen99
I cant see import, only export, where is it ? I also try to write my own script :] THX for help:]
Posted: Sat Feb 14, 2004 6:44 am
by patrikG
in phpMyAdmin go to SQL. Set it so it phpMyAdmin knows that your are uploading CSV and then upload your CSV-file.
Posted: Sat Feb 14, 2004 11:12 am
by Citizen99
ThX