Page 1 of 1

Large Excel File to MySQL database file

Posted: Wed Dec 11, 2002 9:12 am
by AirDavid
I have just started using MySQL and PHP on my web site. I have a large excel file that I would like to get into the new database file on the web server. Is there any easy way to do this with out re-typing my data. Thanks for the help. David

?>

Solution

Posted: Wed Dec 11, 2002 10:55 am
by v1ruz
Try to save the excel sheet as a .csv (comma separated value) and import it with the php interface "phpmyadmin". if you need more help, message me (pm, email or icq 61231225)

cu
v1RuZ