Large Excel File to MySQL database file

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
AirDavid
Forum Newbie
Posts: 2
Joined: Fri Aug 16, 2002 9:42 pm

Large Excel File to MySQL database file

Post 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

?>
v1ruz
Forum Newbie
Posts: 1
Joined: Wed Dec 11, 2002 10:55 am

Solution

Post 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
Post Reply