Is it possible to load and update MySQL tables from Excel, and if so how? I havn’t been able to find any source code.
Excel supports External Data Sources. In this case you set up a system ODBC driver and can access it in Excel.
Here’s a step by step instruction
dev.mysql.com/doc/refman/5.1/en/ … excel.html
While we’re at it, here’s how it would be done with MS Access
Will this work in both directions? I need to send data rom Excel to MySQl.
Excel has the Microsoft Query window that can be accessed via the External Data toolbar. It can be set to allow the user to edit data under “Records”->“Allow Editing”. I don’t think that there’s an easy way to “tie” data between Excel and an SQL database bi-directionally (MS SQL Server or MySQL). You can use VBA scripting within Excel to accomplish this functionality, but this probably isn’t what you had in mind.
I think what may be relevant for you is to use MS Access as a Frontend to MySQL. This is done via Linked Tables, which is described here.