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