Import Excel to MySQL Database

25 Comments

1. foobarph says:

   July 1, 2011 at 12:37 pm

   whoah, i thought you’re going to create an sql statement but i was wrong. sleek move! great!
2. zaibkhanzk says:

   July 1, 2011 at 12:57 pm

   Hello this is zaib,

   The video “Import Excel to MySQL Database ” is very nice and easy. Its excellent. Thanks alot.
3. zaibkhanzk says:

   July 1, 2011 at 1:27 pm

   Hello this is zaib,

   The video “Import Excel to MySQL Database ” is very nice and easy. Its excellent. Thanks alot.
4. blowtar says:

   July 1, 2011 at 2:19 pm

   THANK YOU SOOOOO MUCH!!!

   I was stressing out why my data wouldn’t import, I wasn’t adding the comma so my fields wouldn’t separate lol.

   Thanks for the help man seriously.
5. bliksum58 says:

   July 1, 2011 at 2:43 pm

   Thanks a stack for this illustration!!!!! This has been very helpful.
6. luxmeh says:

   July 1, 2011 at 3:02 pm

   thank you thank you so much..its really helpful!!
7. ThePantrey says:

   July 1, 2011 at 3:09 pm

   thank you very much!!!!!!
8. gourmet10 says:

   July 1, 2011 at 3:10 pm

   Thank you SOOOOO much. This is so much faster and cheaper than purchasing conversion software. Again, thank you.
9. hisdness1 says:

   July 1, 2011 at 3:47 pm

   Awesome
10. myhomeonoahu says:

    July 1, 2011 at 4:39 pm

    thank you !
11. bungurdy says:

    July 1, 2011 at 4:53 pm

    Awesome tutorial! Interesting! thank you,
12. keertishrimali says:

    July 1, 2011 at 5:07 pm

    Really great …It was very helpfull to me ….Thanks A lot
13. N00SA says:

    July 1, 2011 at 5:34 pm

    Thank you!
14. MyThunder77 says:

    July 1, 2011 at 5:48 pm

    thanks a lot. it works fine ….
15. MyThunder77 says:

    July 1, 2011 at 6:15 pm

    thanks a lot. it works fine ….
16. wrdeboise says:

    July 1, 2011 at 6:45 pm

    my excel csv file is adding a lot of extra commas at the end causing extra empty fields to be created in my db. How can I fix this? Thanks.
17. imkb010 says:

    July 1, 2011 at 6:53 pm

    @chungwufeiQ
    Check out the PHP filesystem functions in the php documentation
    That will probably give you a way to go through the files in the directory and save them as .csv files automatically.
    Then connect to database using mysql_connect()
    Then open and parse the .csv files using fopen() and fgetcsv()
    Then insert each row of csv data into your table with the query. You’ll need to use a while statement
    INSERT INTO table_name SET column1_name = ‘value’ … etc
18. LeoNazDo says:

    July 1, 2011 at 7:06 pm

    gradebook_import.csv should be your target ^^ nice tutorial, and thx a lot.
19. admart3 says:

    July 1, 2011 at 7:56 pm

    Thanks, really helped
20. chungwufeiQ says:

    July 1, 2011 at 8:15 pm

    i am trying to create a system that would automatically import excel file to mysql… do u have any how should i do it? i don’t want the user to save the excel file to csv, what i want is that the system would choose the file and make it a csv file… can you help me? thanks a lot… anyway this video really gave me a little idea and helped me a lot.. thanks more power
21. luespi2006 says:

    July 1, 2011 at 8:26 pm

    a little mistake you uploaded the first file instead of the new one in which you added _import to the name, in that file you did ereased the headers, but you choosed the one with the headers still there
22. luespi2006 says:

    July 1, 2011 at 8:28 pm

    thanks a lot indeed

    you rock

    great awesome

    this is totally outstanding

    man oh god you do rock big time!!!!!!!!!!!!!!!!!!!!!!!!
23. amirkoklan says:

    July 1, 2011 at 9:24 pm

    greaaaaaaaaaaaaaaaaaaaaaaaattt
24. fdmomtaz says:

    July 1, 2011 at 9:51 pm

    thanks man, it was great
25. mijz08 says:

    July 1, 2011 at 10:27 pm

    i can’t access to cPanel how am I going to do??