Excel Import MySQL Table with ODBC Database Query
Вставка
- Опубліковано 21 жов 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!
Thank you so so so much for putting this up. I've been struggling with this the whole week
Really life saver !!!! Superb have been struggling for days now and have finally figured how to connect. Thank you so much...
Hello. Thank you for great tutorial. It's possible to insert/edit mysql data directly from excel? Thank you.
How can I use a custom SQL query in this ODBC connector?
Can we able to make customized excel Query to pull data with filter from database ?
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.
excellent Thank you so much , after a lot of video i get to complete conection and get data directly from MySql tables.
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
great video
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?
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
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?
very thank you,it's a very usefully video.
What do you do if the it failed to connect?
Can anyone help how to use Excel with Mysql on Macbook?
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?
Thank you!
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.
Luv uuuuu
thank you so much
graaaaaaaaaaaaaciaaaaaassssssssssssssssssss (thanks
Thanks for that video!