MySQL for MS Excel

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

This is how it looks like:


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:


And the magic happened:


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!

Tagged with: , ,