Here's one way to get your Excel file into MySQL via phpMyAdmin:
(NOTE: make sure your table on MySQL has the same number of columns as the excel file):
1. Export your .xls file to .csv and remove the first line (column names)
2. Launch phpMyAdmin -> select table
Import ->
Location of text file ->
CSV using LOAD DATA ->
Fields terminated by [,] ->
Fields enclosed by [ ] ->
Fields escaped by [ ] ->
Lines terminated by [r] -> Go
Again your awesome. Thanks a ton.
Thank you! This was a BIG help.. I have a small problem now, what if some of my fields already have commas within the entries – how would i go about fixing that?
I’m amazed this helped everyone so well. Eveyone shows the command to load the file but no one shows an exaple of what the fiile should look like. Does anyone care to show an example of what the file should look like? (the file that you are importing)
You are probably the only man who knows how to import csv data. Thanks a ton. Can u pl. tell me the reason for using /r in the field “Lines terminated by”. Thanks a ton again.
Thanks for the post!!! you have saved me lots of time dude!!!!
Beautiful!
thanks! much appreciated
great!!!
thanks a lot for this men…
😀
Seriously, you don't know how many people have been challenged with problem, and you made it look so simple. It's a gift i guess. Thanks, you're the Best…