ODBC to MySQL question

[Shawnyv]

Hey all,

So I'm currently using the ODBC connections to grab data from a MySQL database so I can work with it in Excel.

Is there a way to use the same connection to update the MySQL tables with data from a worksheet via VBA?

I just installed the MySQL for Excel utility from Oracle (HUGE NIGHTMARE that broke my old macros grabbing info from the databases) hoping that I'd be able to create a macro that could do that, but to no avail. When I try to grab some base code by starting the macro recorder & using the "MySQL for Excel" utility, nothing gets written.

So I started wondering if there was any way to do it at all.

Anybody currently doing this, and willing to help me along?

 

[Kyle123]

Can't you just use the MySQL driver and connect over ADO, using the utility looks like hard work