Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

how to store values(data) from excel into mysql  RSS feed

Ranch Hand
Posts: 117
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!