How to import data from Excel to Mysql

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
amir
Forum Contributor
Posts: 287
Joined: Sat Oct 07, 2006 4:28 pm

How to import data from Excel to Mysql

Post 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!.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post 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.
amir
Forum Contributor
Posts: 287
Joined: Sat Oct 07, 2006 4:28 pm

Post by amir »

Everybody knows that you are very intelligent but i am expecting some softwares to do that e.g. sqlyog or etc.

Thanks.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post 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.
amir
Forum Contributor
Posts: 287
Joined: Sat Oct 07, 2006 4:28 pm

Post by amir »

You are right.
I am sorry! :cry:
I 'll try not to do it again.
Thanks and cheers.
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

Excel:
File -> Save As... (Choose CSV).

phpMyAdmin:
Import -> Type is CSV

Done.
amir
Forum Contributor
Posts: 287
Joined: Sat Oct 07, 2006 4:28 pm

Post by amir »

Thanks Guys.
Cheers.
Post Reply