MySQL for MS Excel

Yes, it exists! Today, I somehow managed to install it from here.

This is how it looks like:

my_sql_excel1

Just a small icon in the Excel data tab. Once you click, you are asked to make the connection with the DB. Due to some happy coincidence, I have recently studied PHP and MySql and I still had XAMPP with some MySQL databases there. So, I just tried to get into the DB:

my_sql_excel2

And the magic happened:

my_sql_excel3

You may even export the data to mySQL database from excel with this small tab. And the best thing with this app is that it comes for free! 🙂 Like the whole MySQL DB.

That is all. Enjoy it!

About

VBA Developer

Tagged with: , ,