Excel Import MySQL Table with ODBC Database Query
Vložit
- čas přidán 11. 09. 2024
- Use the Query editor (Power Query) to import a MySQL table into Excel using the ODBC Connector for MySQL. Importing the table in this way allows for automatic refresh.
Download the MySQL ODBC Connector to use with Excel here (make sure you match the architecture to that of your Excel install!): dev.mysql.com/...
Written tutorial: syntaxbytetuto...
Best thing since sliced bread - this tutorial. I've battled with disjointed advice from my ISP for a week at least, but your clear instructions.... hey presto, up-&-running in minutes. Thank you!
Really life saver !!!! Superb have been struggling for days now and have finally figured how to connect. Thank you so much...
Thank you so so so much for putting this up. I've been struggling with this the whole week
excellent Thank you so much , after a lot of video i get to complete conection and get data directly from MySql tables.
Hello. Thank you for great tutorial. It's possible to insert/edit mysql data directly from excel? Thank you.
great video
very thank you,it's a very usefully video.
How can I use a custom SQL query in this ODBC connector?
Thanks for that video!
hello thanks for video and i have a question. I didnt see tables when im adding after the odbc connection. I see the databases but tables doesnt show.. How can i add thata tables to excel?
Hi can you please tell me why you did not go for Data-->Get Data--> From DataBase-->From MySQL? Thank you very much.
That option asks me to install some other component and I think this way has greater backwards compatibility.
Can we able to make customized excel Query to pull data with filter from database ?
Thank you!
Sometimes when I reference a cell from a PowerQuery table elsewhere in my workbook I get a #REF! error. Do you know what causes this and how to fix it?
iam also importing mySQL data into excel. when i enter password it says "{the given key is not present in the dictionary'}. tell me how to resolve the issue.
iam using windows 11. student version of microsoft 365
What do you do if the it failed to connect?
Thank you for this clear tutorial. I would like to ask on how to connect on a remote server with ssh in excel?
I don't really know what you mean. What are you trying to accomplish?
Hii can you answer this question ?
In database i have different tables how to get data from all the tables present in the same get and transform page
You can create a query for each table and then merge them into a single query, and load that query.
Is it possible to make it auto refresh every 5 seconds? (I know you can make it from 1 minute to 32k minutes, but I need it to refresh every 5 secs. reason, is that it's reading sensors in a real environment, and I'm using Excel as a control dashboard)
Looks like you can use VBA, never tested myself stackoverflow.com/questions/18916445/excel-2010-more-frequent-external-data-refresh-with-vba
Luv uuuuu
When I tested the connection. Connection failed. How can I fix this?
I mean, there could be many reasons your database connection is failing. Are you able to connect to the database using the same information with other tools?
graaaaaaaaaaaaaciaaaaaassssssssssssssssssss (thanks
Can anyone help how to use Excel with Mysql on Macbook?
How to make this work using a phpmyadmin web server?
phpMyAdmin is not a server, it's a database management software. Your use of it or not will not change any of the instructions in the video. You need to find your connection details for the SQL server and use those.
thank you so much