Import Excel to MySQL Database

15 Responses to Import Excel to MySQL Database

1. yourherojake says:

   March 5, 2010 at 8:56 am

   Great tutorial. Thank you! You just cured my headache.
2. anandmohan88 says:

   March 5, 2010 at 9:14 am

   Use CSV with LOAD data, it took me a while to figure out why CSV was not working.

   Thanks a lot man.
3. Realcfx says:

   March 5, 2010 at 9:21 am

   nice thanks alot!
4. zsebyagain says:

   March 5, 2010 at 9:51 am

   thank a lot
5. spaedy4ever says:

   March 5, 2010 at 10:36 am

   THANKS!
6. dalv11 says:

   March 5, 2010 at 11:16 am

   THANK YOU!!!! VERY HELPFULL!!!
7. themoosemind says:

   March 5, 2010 at 12:08 pm

   If you want to import with CSV-Option, you have to list the fields you want to import, seperated with comma (“,”)
8. uniquestory says:

   March 5, 2010 at 12:11 pm

   Very helpful tutorial. Thanks a lot!
9. JeTSpice says:

   March 5, 2010 at 1:06 pm

   I’m a hero at work now! Thanks!
10. spaedy4ever says:

    March 5, 2010 at 1:44 pm

    THANK YOU SO MUCH
11. draponix says:

    March 5, 2010 at 1:58 pm

    This helped me loads, Thanks!
12. ferrersr says:

    March 5, 2010 at 2:24 pm

    With Mac the end of line is r not n like on Windows
13. philliph22 says:

    March 5, 2010 at 2:28 pm

    thanks, great tutorial.
14. RecoDesign says:

    March 5, 2010 at 2:34 pm

    I got all the rows affected when I did it with CSV. Only 1 row affected with CSV using LOAD DATA.
15. RecoDesign says:

    March 5, 2010 at 3:01 pm

    Why did I only get 1 row affected?