Hi experts , I have created ODBC connection from my excel sheet to mysql database called test, now I can see all the values stored in test in my excel sheet , but
I don't know how to save/store new values(data) inserted from excel sheet into mysql . I mean that I can add more data to my database not directly but through excel sheet
and why I do that because I want to use excel facilities and functions for calculation.
please help me in how to acheive that
thanks a lot
subject: how to store values(data) from excel into mysql