Page 1 of 1

How to import data from Excel to Mysql

Posted: Mon Nov 27, 2006 2:55 pm
by amir
Hello.
I have just made a student management system.
I can enter records one by one and the system is working perfectly. I have an Excel file having 500 students information. I want to upload that data to mysql database without entering each record.
TIA!.

Posted: Mon Nov 27, 2006 3:02 pm
by feyd
You've had three posts on the same basic thing. And each time I've responded with check out the Excel file reader from PEAR. I'm getting tired of answering this question from you and will do so no longer.

Posted: Mon Nov 27, 2006 3:20 pm
by amir
Everybody knows that you are very intelligent but i am expecting some softwares to do that e.g. sqlyog or etc.

Thanks.

Posted: Mon Nov 27, 2006 3:23 pm
by feyd
Posting in the code sections would suggest you want code, not an application. Plus, nothing in your posts have suggested you were wanting an application. If that's what you want, say so; don't create yet another thread later that asks the same thing only a little different.

Posted: Mon Nov 27, 2006 3:35 pm
by amir
You are right.
I am sorry! :cry:
I 'll try not to do it again.
Thanks and cheers.

Posted: Mon Nov 27, 2006 5:20 pm
by RobertGonzalez
Excel:
File -> Save As... (Choose CSV).

phpMyAdmin:
Import -> Type is CSV

Done.

Posted: Tue Nov 28, 2006 6:42 am
by amir
Thanks Guys.
Cheers.