Hi All
I have posted this earlier but although 84 people read it nobody seemed to have a solution for me.
I am trying to link a worksheet to a MySQL table using odbc. As I change the value in a cell then it has to update the value in the database.
I can retrieve the data perfectly but I cannot get it to write back. Also, all connections are dropped when I close the worksheet are not re-established when I reopen it.
I have tried using the MySQL addon for excel and this works perfectly except that I have to manually link every table again everytime I open the spreadsheet (about 30 tables in total).
Has anybody got a solution for me
Thanks
Steve
Bookmarks