Update MySQL database using Excel VBA

[Lane]

Dear Excel experts,

I would like to use Excel VBA to update data on a database. I am using a web database running MySQL. My Excel-sheet is collecting data in real-time. Iwant to get it to update database as data is being collected. May I ask the experts here whether this is even possible with VBA?

Thank you very much for your help.

 

[Greg Glynn]

Hi Lane

Dear Excel experts, I would like to use Excel VBA to update data on a database. I am using a web database running MySQL. My Excel-sheet is collecting data in real-time. I want to get it to update database as data is being collected. May I ask the experts here whether this is even possible with VBA? Thank you very much for your help.

It certainly is. Which version of Excel are you running? If it is Excel 2003 I recommend Conrad Carlberg's most Excellent book "Managing Data with Microsoft Excel"

At any rate the first step is to install the ODBC drivers for MySQL
http://dev.mysql.com/downloads/connector/

Then you need to setup your connection using the MS ODBC Data Sources config.
odbcad32.exe (Should be in your \Windows\System32 folder)

Then the fun begins.