Import Data from excel to MySQL

If you want to Import data to MySQL table from excel sheet, then follow the following instructions.


-Your excel sheet as:

rollno name marks
1 vanesh  78
2 ganesh  88
3 ramlal  70
4 ramesh  68

-Create mysql table student, contaiing follwing colums:


-Save table. now your table created.
-Go to excel sheet, remove first row. i.e.
rollno name marks

-and save excel sheet as .csv file
 (make sure your file is saved as .csv extension for example student.csv)

-Now go to your PhpMyadmin
-Select your table
-Click on Import
-Choose File
-Click on GO Button.

--Your excel data is now imported successfully.

-Check it by clicking on Browse.

I think, it may helps you.

Expecting your feedback. 

(Article Submitted By --Vanesh Mali, SOFTWARE ENGINEER @Pune)

No comments:

Post a Comment

We are here to listen you, Comment your valueable opinion...!!!