This an excellent video and I wish I have found it long time ago. I am wondering how one can go one step further by creating a sort of form to show the query/queries results to add,edit and update the database via Excel? Something like to be able to select a customer/company from drop down box, then see all its details and probably its employees, orders, etc and be able to update these details? I would appreciate any help. Thank you.
How we can update MySQL database using Excel query described in this video? ( when the query is pulling the data from several MySQL tables). Please advise
Hello, if i have an existing MS SQL SERVER query, would i be able to plug that sql somewhere on excel once I complete the excel data connection to the database?
+Hubert Asuncion I am unable to understand the exact question.. If you can help me with details, ill try and help u out the best I can.. Thanx for watching 😊
Hi Need for Excel, can i use Import Data Using SQL Queries & Stored Procedures if my sql creates a custom table? For example the sql i want to use creates a custom table, and the second query selects data from that custom table to create a summary.
I have question is there any Chance to connect with MySQL directly via Power Query with a servers details and SQL query like for SQL servers. I am talking about excel 2016. There is option such: Data -> From Data Bases -> From DataBase MySQL once I choose this option I have sych announcement: To use this connection You have to install at least one add-in. But what Add-in excel is talking about:/
Ok, it doesn't work when You choose "From MySQL Database" but it does work when You choose from "Other Sources" -> "Sources ODBC". This will open posibility to download by the SQL query any table that You can access on the given MySQL DataBase You have access too, brilliant. I really love it….great job. Thx again for solving my big problem with setting up connection, best regards:)
giannispets hi, is there any video on how you can update myql when you make changes in the excel file? you said something about an update query but i can find something. Also thanks for your helpfull video :)
Hi and thanks for the reply. I want to reverse the process after extracting to excel, to be able to update fields manually and push the data back again to mysql database. For example... in your excel you have on line 1 products: oiltank | quantity: 98 etc. I want to change the value quantity manually to 90 and update after the database with the new value 90
Glad you find the video useful.. :) Here are my exercise files - www.dropbox.com/sh/gek8yvzmzeyemhy/AADDN1TNufCGRdttOSAbZT7Ya?dl=0 However, there is no particular exercise file for this video.. Let me know if you need anything else.
Hi it helped and worked well. I just would like to write that some of the uesers might get this Error: "mysql connector connection failed [hy000] connection using old". To succeed in connecting database user have to ask MySQL server Admin to change this users password type from security standard old version of 16 hashes to 41 hashes. Without this change conneciotn will be impossible, because users computer will expect password on the server in new standard of 41 hashes but might receive 16 which is treated as an error of the conneciotn. There is an instruction for server Admin to proceed with changing users password standard: nixcp.com/mysqlnd-cannot-connect-mysql-4-1-using-old-insecure-authentication/
What an awesome demo, I just bumped into it with doing MySQL research but it was worth every second. Kudos Need For Excel.
Thanks a lot sir.. Glad you liked the video 😊
Very nicely done! Big Help! Thanks a lot!
Great tutorial
Excellent tutorial, so clearly explained and easy to follow. Well done, thank you.
Thanks a lot! What a great teacher you are!
+Calvin Fuss Thanks a lot for your kind words 😊
You saved my life big
Very informative instruction! Thank you!
+Dave Myers Thank you for watching! 😊
This is really good video.
EXCELLENT!
you've just save my life! tks!
+Ariana Moral No worries!! Glad u enjoyed it 😊
life saver, thanks man!
+Joshua Buche Thank you for watching 😊
Great solution, thanks!
nice video!
Process to make this videos is very knowlegable
Thank you for watching sir! :) I am glad you find the videos useful..
Is it possible to pass parameters to the mysql query like date range using same mysql connection?.
Please suggest
This an excellent video and I wish I have found it long time ago. I am wondering how one can go one step further by creating a sort of form to show the query/queries results to add,edit and update the database via Excel? Something like to be able to select a customer/company from drop down box, then see all its details and probably its employees, orders, etc and be able to update these details? I would appreciate any help. Thank you.
How we can update MySQL database using Excel query described in this video? ( when the query is pulling the data from several MySQL tables). Please advise
Hello, if i have an existing MS SQL SERVER query, would i be able to plug that sql somewhere on excel once I complete the excel data connection to the database?
+Hubert Asuncion I am unable to understand the exact question.. If you can help me with details, ill try and help u out the best I can.. Thanx for watching 😊
Hi Need for Excel, can i use Import Data Using SQL Queries & Stored Procedures if my sql creates a custom table?
For example the sql i want to use creates a custom table, and the second query selects data from that custom table to create a summary.
I guess to paraphrase, can I select from a custom table using power query? The custom table being the sql i have created.
I have question is there any Chance to connect with MySQL directly via Power Query with a servers details and SQL query like for SQL servers. I am talking about excel 2016. There is option such: Data -> From Data Bases -> From DataBase MySQL once I choose this option I have sych announcement: To use this connection You have to install at least one add-in. But what Add-in excel is talking about:/
Ok, it doesn't work when You choose "From MySQL Database" but it does work when You choose from "Other Sources" -> "Sources ODBC". This will open posibility to download by the SQL query any table that You can access on the given MySQL DataBase You have access too, brilliant. I really love it….great job. Thx again for solving my big problem with setting up connection, best regards:)
giannispets
hi, is there any video on how you can update myql when you make changes in the excel file? you said something about an update query but i can find something. Also thanks for your helpfull video :)
+giannispets Can you briefly explain what your requirement is. I can try to make a video for the same. Thank You and sorry for the late reply
Hi and thanks for the reply. I want to reverse the process after extracting to excel, to be able to update fields manually and push the data back again to mysql database. For example... in your excel you have on line 1 products: oiltank | quantity: 98 etc. I want to change the value quantity manually to 90 and update after the database with the new value 90
man when i click add no MySQL ODBC 5.2 ANSI driver on my list , can you help me please
Which Excel versions are you using?
thanks but how update update mysql data from a change excel data list. it is okey?
+ahmet faruk güneş Do you want to change the data in your mySQL database one you update excel? Is that right? You can use ADODB with an update query..
is there any video for this? i mean with the update query. Also thanks for your helpfull video :)
Superb! Solution to many problems, Cant Find the exercise files
Glad you find the video useful.. :)
Here are my exercise files - www.dropbox.com/sh/gek8yvzmzeyemhy/AADDN1TNufCGRdttOSAbZT7Ya?dl=0
However, there is no particular exercise file for this video..
Let me know if you need anything else.
Thank you, sir!
+bat vulcho Thank You for watching 😊
thank you.
+dous mohammed Thanks for watching sir 😊
awsoooooooooooooooooooomeeeee :-*
+Omaaar Omar Thank You for watching 😊
Hi it helped and worked well. I just would like to write that some of the uesers might get this Error: "mysql connector connection failed [hy000] connection using old". To succeed in connecting database user have to ask MySQL server Admin to change this users password type from security standard old version of 16 hashes to 41 hashes. Without this change conneciotn will be impossible, because users computer will expect password on the server in new standard of 41 hashes but might receive 16 which is treated as an error of the conneciotn. There is an instruction for server Admin to proceed with changing users password standard: nixcp.com/mysqlnd-cannot-connect-mysql-4-1-using-old-insecure-authentication/
Hey, i have added data source with same driver in 64 bit ODBC but i cant find my data source while getting data from microsoft query. Please help.