Thanks for the video, it also worked for me. I tested it with multiple sheets and it happens that each will be considered as a separate table. 1 thing to take note is that if you enter values in certain cells and delete the entries, excel somehow keeps them as important to your worksheet but just empty, when you import to database, the empty cells will also be imported and you will end with more columns with letter names and null as rows. Excluding importing null values fails
Very good. No need to buy a special app to do the job. By the way I suppose that saving it in the doc format strip the file from all the information that makes an excel file . Just like exporting it to a cvs format then importing it to the MySQL workbench. Great video , thank you !
bt what happend we have already more than a table and we just wanted to add a record to table 1 not in table 2 in that case we dont have any table selection option here .. what we do for this??
Thanks for the video sir. Now, the only thing is that I have a table already created; - and using the method that you show in the video. The file is imported, but a whole new table is created, the data is not added to the table I select. Why this could be happening?
Juan, I could not tell you without seeing what you are doing. One thing you could do is to create a testing table, and then try to import into that testing table (using testing data). If you get the same problem, then do a screen recording and share it. I suggest the testing table, that way you can share the screencast without exposing your real data. If need be, I am willing to connect and assist you if need be. Kindly, Edward Lara
@@edwardlara4912 I've done exactly what you did but in the end after I load the file it doesn't complete the query and I get a blank page. I don't have privileges on the database does that have anything to do with it?
Anubhav, not sure what you are trying to do, but there is no link between MySQL and the spreadsheet. Consider this to be an "import", and once done is done. You can always "import" the data again. I'd mainly use this for a one-time "import". If you need to keep a live connection, then you need another solution.
¿Valerio Lara? En verdad no estoy seguro. My familia es original República Dominicana. Bendiciones para ti también. Por cierto, te invito a mi canal en español (materiales de la Biblia): th-cam.com/channels/Y6WI008CVL4-FW1eskgdOQ.html
Because my Table has 85 columns, and I can't make structure manually.I found very fast and elegance decision Search - ( excel2mysql es ) - online very useful tool. Converts .xsls , xls , csv files to SQL code for easy import in database.
When using what I showed in the video, 99% of the time, you will transfer data to an empty table. You should be fine if you already have a table and your data is well-formed. The statement does try to create a table if it does not exist but otherwise is an INSERT statement.
I wish I could like this video more than once. It has been so very helpful, and so very well explained in an uncomplicated way. Thank you so much.
Thanks.
short and to the point . the best kind
Thanks for the video, it also worked for me. I tested it with multiple sheets and it happens that each will be considered as a separate table. 1 thing to take note is that if you enter values in certain cells and delete the entries, excel somehow keeps them as important to your worksheet but just empty, when you import to database, the empty cells will also be imported and you will end with more columns with letter names and null as rows. Excluding importing null values fails
thanks
thank god, a tutorial without an indian accent, it was driving me crazy :P
You don't understand indians accent?
Love the “ITS DONE” very good video 👍
Very good. No need to buy a special app to do the job. By the way I suppose that saving it in the doc format strip the file from all the information that makes an excel file . Just like exporting it to a cvs format then importing it to the MySQL workbench.
Great video , thank you !
I'd suggest you give your theory a go and see if it works. Cheers!
omg, you are so amazing. just what I was searching for.... thank you
How to impliment this in a front end admin panel of a flutter project?
this video was such a life saver, thank you very much.
It saved our life.
Glad to know that this was helpful. Kindly.
Привет, очень помог при портировании экселя с 248 тысячами строк в базу, лучший!
This was such a huge help!!, thank you
hello sir thankyou for the tutorial. it works!
Sup! Anytime.
do you also read for audiobooks, sir? because you should
Thanks for the compliment. Best to you my friend. Kindly, Edward Lara
Bro you just saved me Thank You
Hey your video helped me a lot. Thanks Bro
Super. 👍
Thanks a lot, man. It worked for me. Appreciated.
thank you man you saved me
Hi Carlos. After great video, review LoaderDataPlus tool. This tool import flat files and export to MYSQL, MARIADB sintax and other DMBS.
Thanks a lot method is really work!
Nice video, great voice, man. You should do more online courses... wow
Thanks, it worked 100%
Does it's store only some amount data or we can import 1lakh also
bt what happend we have already more than a table and we just wanted to add a record to table 1 not in table 2 in that case we dont have any table selection option here .. what we do for this??
did you get it?
if you did,please let me know how.Thanks
great work man
Good work man
thanks a lot.
It helped me a lot,thank you!
You're welcome!
Thank you so much! You saved me ;)
Great! Cheers!
Doesn't work for me. It keeps creating a new table each time I import.
still working awesome video. thanks
this video is amazing. Thanks so much.
Awesome boss
hello my friend i tried importing my data but i'm getting phpMyAdmin - Error
Incorrect format parameter
Awesome, thanks for sharing!
You attempted to load file with unsupported compression (application/zip). Either support for it is not implemented or disabled by your configuration.
Exactly, did you resolve it?
thank yoooooooooooooooooooooooooooooou ...You saved me
Thanks for the video sir. Now, the only thing is that I have a table already created; - and using the method that you show in the video. The file is imported, but a whole new table is created, the data is not added to the table I select.
Why this could be happening?
Juan, I could not tell you without seeing what you are doing. One thing you could do is to create a testing table, and then try to import into that testing table (using testing data). If you get the same problem, then do a screen recording and share it. I suggest the testing table, that way you can share the screencast without exposing your real data. If need be, I am willing to connect and assist you if need be. Kindly, Edward Lara
Can we do that using popsql?
I don't use PostgreSQL, if that is what you mean. Give it a try, and let us know. Cheers!
hello sir, what about after connecting it on mysql table, why not to try to connect it the pycharm?
Amazing
i want to upload 45000 rows excel data sheet.is it possible in this way
In theory, yes. Give it a go, and let us know.
After I loading a file I get a white/ blank screen and I'm using online database... Any idea on how to fix it?
Without sharing more info, I won't know how to answer the question. Did you save the spreadsheet in the OpenDoc format?
@@edwardlara4912 I've done exactly what you did but in the end after I load the file it doesn't complete the query and I get a blank page. I don't have privileges on the database does that have anything to do with it?
Nice, I'll think about this later
Thanks for sharing
Really helpfull. Thank you
Thankyou for your video.Its useful
Thankyou somuch you made my day
How to import data from Excel when it is having multiple sheets
The same way. The process shown in the video works with one or multiple sheets.
Very Help full, thanks
If we change to the open spreadsheet data, changes aren't reflecting in MySQL data..pls help!
Anubhav, not sure what you are trying to do, but there is no link between MySQL and the spreadsheet. Consider this to be an "import", and once done is done. You can always "import" the data again. I'd mainly use this for a one-time "import". If you need to keep a live connection, then you need another solution.
@@edwardlara4912 ya i need a live connection. Can u pls guide me through. Any links wud be appreciated
Thank you very much. for this.
Anytime.
Thank you for this video. i am tried to find the correct solution to import ARABIC data into mysql data bas. THANK YOU ALOT
Ensure that Encoding=‘UTF8’ !
Gracias Edward Lara. Acaso familia de Valerio Lara? Eres un experto. Dios te bendiga.
¿Valerio Lara? En verdad no estoy seguro. My familia es original República Dominicana. Bendiciones para ti también. Por cierto, te invito a mi canal en español (materiales de la Biblia): th-cam.com/channels/Y6WI008CVL4-FW1eskgdOQ.html
@@edwardlara4912 Yo soy Dominicano. Tu voz es extraordinaria. Sácale provecho!
Gracias por tu comentario y motivación. ¡Bendiciones!
Gracias por las palabras de motivación.
cool stuff
Thank you so much.
good
Thx
Anytime
thanks
helpful for me thanks
Subscribing now!
Thanks 😊
Anytime.
Cool
Because my Table has 85 columns, and I can't make structure manually.I
found very fast and elegance decision Search - ( excel2mysql es ) -
online very useful tool. Converts .xsls , xls , csv files to SQL code
for easy import in database.
Great! Easier is always better
Thank you
thank good
source code plz.....
Спасибо!
Не за что!
if the database connected with foreign key its not worked, so what the solution for foreign key and autoincrement column?
When using what I showed in the video, 99% of the time, you will transfer data to an empty table. You should be fine if you already have a table and your data is well-formed. The statement does try to create a table if it does not exist but otherwise is an INSERT statement.
thanks
Thank you
Thanks
Thank you
You're welcome
Thank You