Import Excel to MySQL Database

[MrAbwolf]

Hello guys, this is a great video. When i used it first time than i understand at once all method.I use this video and i did a litle notice on my blog. You find it on abwolf.com.

[MrEG12341]

All the fields I get are NULL, why does this happend?

[aiyer10]

thanks for this video. Very helpful.

[sumguyx2x]

Very good this is helpful to me.

[bobowa]

very cool, you are the best!!!!

[neweranda]

Thanks. Very Useful. Good Luck

[empireones]

f-ing love you man....

[spiderpig4444]

is it possible to import xls straight to php without converting the file to csv?

[huejiitechx]

is it possible that data from mysql imported to excel

[saidj005]

Dear Sir, I am imorting same data from mysql but the date its in the wrong format. for ex 632525515609177000. How can i solve it

[globalinfocom]

thanks for this

[toroduque]

THANKS A LOT!!! You just save my life!

[makingamessofthings]

Its a lot easier watching you do this, than it is watching me do it. Thankfully, now its not as bad as was when I started a couple hours ago! Thanks!! Off to work!

[johnliverpool1000]

Thanks great work and very helpful

[william97035]

Thanks for the video instruction. Well done. Spent several hours trying this and that until I found your video. Straightforward and effective.

[vigante]

Very helpful. Thank you!

[criiminal9090]

genial

[ixtradebiz]

thanks for this tutorial! :)

[s7ntech]

I would suggest this site for generations of sql query from a file excel

s7ntech . altervista . org/utility/s7xlstosql

[mrkoekie]

the reason why you had the student, test1, test2.... row, is because you saved the csv file as "Gradebook_import.csv"

The rest.. BRILJANT

[ellsworthhouse94705]

What happens if you have commas in some of your data?

[kierkegaardrulez]

@ellsworthhouse94705 You see "Fields terminated by", "Fields enclosed by", and "Fields escaped by"? Excel should save csv's with quotes around every text field, so you can have as many commas as you want. Instead it only puts quotes around fields that contain commas. Try exporting as csv and look at the resulting file in notepad.

Where Excel completely screws up is escaping double-quotes ("). It should put slash in front of them"\", but instead it puts another double quote. Use Open Office..

[webcd80]

Great tutorial, the first one i've ever used without a hitch!

[bloodytoy3]

thanks will try it out later! :)

[Defmonkful]

very helpful video....thanks

[ghodium]

how much does the database weigh?

[Ruunerwold]

thanks man! When I used CSV using LOAD DATA it worked like a charm

[tomcatbilli]

Thank you, i was in trouble and you solve my problem

[TheAshodpuck]

thank you thank you thank you !!! you rules!!

8:49.... Psychological study of... hahahaha!!!

[TOMTOM171717]

you don't need to check the field when you delete unless you are using the controls at the bottom of the table

[melowise]

Thanks man this tutorial was great. That last aprt about the CVS load was the trick. Thanks again.

[vba4accountants]

awesome video bro, thanks !

[venkykeerthi]

Superb, thank you very much....

[drascatube]

great great great! you r absolutely awesome! this saves me tones of work! Thanks very much!

[foobarph]

whoah, i thought you're going to create an sql statement but i was wrong. sleek move! great!

[zaibkhanzk]

Hello this is zaib,

The video "Import Excel to MySQL Database " is very nice and easy. Its excellent. Thanks alot.

[blowtar]

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.

[bliksum58]

Thanks a stack for this illustration!!!!! This has been very helpful.

[luxmeh]

thank you thank you so much..its really helpful!!

[ThePantrey]

thank you very much!!!!!!

[gourmet10]

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

[hisdness1]

Awesome

[bungurdy]

Awesome tutorial! Interesting! thank you,

[keertishrimali]

Really great ...It was very helpfull to me ....Thanks A lot

[N00SA]

Thank you!

[MyThunder77]

thanks a lot. it works fine ....

[MyThunder77]

thanks a lot. it works fine ....

[wrdeboise]

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.

[LeoNazDo]

gradebook_import.csv should be your target ^^ nice tutorial, and thx a lot.

[chungwufeiQ]

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

[imkb010]

@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

[luespi2006]

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

[luespi2006]

thanks a lot indeed

you rock

great awesome

this is totally outstanding

man oh god you do rock big time!!!!!!!!!!!!!!!!!!!!!!!!

[amirkoklan]

greaaaaaaaaaaaaaaaaaaaaaaaattt­

[fdmomtaz]

thanks man, it was great :)

[mijz08]

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

[blackdogmanguitar]

Top man! That was a very clear video that solved a problem I had spent hours working on, downloading software that didn't work and banging my head against the wall! Thank you!!

[enjoyjocel]

thanks man..ur the best..great tutorial..u save my ass tonight!..wew!..

[jasonwalker33]

Great tutorial! Thank you for posting it. What screen recording software did you use for this tutorial?

[ozkr2805]

UUUFFFF buen aporte!

[ebayguru1]

You Rock! It drove me nuts getting this working. I also realized that I had to turn off the auto_increment on my first primary field.

[sudarsan7532]

Thanks man it worked for me... :)

But in the Import page you have to select radio button "CSV" and not "CSV with Load Data"....

[willzurmacht]

Wow thank you thank you! You're voice is so clear ^_^

[cinthiamacias]

Gracias!!

[amitktube]

thank u.......but how to Import .sql file Into Wordpress ?

[Tommyboibruv]

Error

SQL query:

LOAD DATA INFILE '/tmp/php0PRDUI' INTO TABLE `Division1` FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n' On 9.52 I keep getting this error:

MySQL said:

#1045 - Access denied for user 'sheppeys'@'localhost' (using password: YES)

Could anyone help me out with this?

[Tommyboibruv]

At 9.52 I cannot go any further because of error 1045. Could someone help please?

[JogosIOL]

Thank you very much!

[fudge867]

thanks very much, this helped a bunch :D

[anayfp]

Thanks a lot for your contibution, I have spent hours and hours of frustated work trying to import my Excel table to MySQL, keep the great Job!. I will say "Cheersss..." with a glass of Tequila saying your name, gracias amigo. Greetings from Mexico!,

[joker4001]

thanks man, it really great tutorial

[jesuslovesme09]

I seriously love you!!!! I've been trying to do this all day and I was at my wits end...I thinking "what am I doing wrong??" Thank you so much for posting this video even though its from 2008...thank you! thank you! Now maybe I can get somewhere :)

[bluefish701]

This was very helpful. Thank You. :)

[mchcreative]

Excellent and easy !  Thank you!

[armusiclive]

Great! Thanks for taking time provide this info.

[FlatspinZA]

When you saved the csv file you had original excel file open so you renamed it to file_import.csv & then imported the original file with the field headers, hence the need to delete the first row with headers.

[dlaurent86]

great tutorial thanks

[Kenbreg]

Nice video but what if your data has commas in it?

[sshelato]

Thank you!

[digitalsimulator]

use dbTube simple to use and no coding, configuration,...

[camusrage01]

what is the url of that page ?

[SolarWaterTV]

Thank you very much! This saved me a huge headache ... Much appreciated. Cheers

[yourherojake]

Great tutorial. Thank you! You just cured my headache.

[anandmohan88]

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

Thanks a lot man.

[Realcfx]

nice thanks alot! :)

[zsebyagain]

thank a lot

[spaedy4ever]

THANKS!

[dalv11]

THANK YOU!!!! VERY HELPFULL!!!

[themoosemind]

If you want to import with CSV-Option, you have to list the fields you want to import, seperated with comma (",")

[uniquestory]

Very helpful tutorial. Thanks a lot!

[JeTSpice]

I'm a hero at work now! Thanks!

[spaedy4ever]

THANK YOU SO MUCH

[draponix]

This helped me loads, Thanks!

[ferrersr]

With Mac the end of line is \r not \n like on Windows

[philliph22]

thanks, great tutorial.

[RecoDesign]

Why did I only get 1 row affected?

[RecoDesign]

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