Is it possible to create a real-time connection between excel and mysql?

The mysql database updates about with new information about once an hour.

What I want to build is a table which has about 50 rows, with the most recent data at the top and the oldest at the bottom.
The entire table is dynamic, so it "rolls" through the data.

We then would want other parts of the workbook to refer to the data and perform calculations on a periodic basis.

I'll appreciate advice and thoughts on this project. (for example... I assume it would require VBA, and perhaps an addin such as the one here: https://www.mysql.com/why-mysql/windows/excel/ )

I can upload a template with notes if this helps.

Thank you!