MySQL Excel Connection automatic
Hi all
I use Excel 2007 and MySQL5.6. I have established connection between Excel and MySQl
using MySQLforExcelConnection (the button at Data ribon tab).
Due to the fact that I have many tables and I must do it for all tables in Database, I am searching a way so every time I open excel file, the connection to be established automatically, update all the tables in excel and also the small window
"Revert Data" "Commit changes" to remain active.
It must be as if I did it manually.
Thank you for help
Christos
Subject
Views
Written By
Posted
MySQL Excel Connection automatic
2455
March 20, 2013 03:09PM
1112
April 03, 2013 10:37AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.