Neverside

MS Excel to MySQL

I am desigining a new website for my college and i was stuck with the examination results page, after creating the page (working with PHP and MySql databse) they told me that updating each record individually takes up much time and effort doing data entry, so they asked me to create an alternative way to import the record from Microsoft Excel (or other CSV files) to my existing table. But i am not that good at PHP and i couldn't make this till now, so hope anyone here could help me with it.

Thanks.

Look for a CSV to MySQL Converter there are heaps out there hotscripts.com has some. Ill try and find mine however you will need to modify it slightly as it was for single situation.

___________________

[WebMobo] [Blog] [Me] [SFX]

waiting