I have a legacy application that the only way to use the data outside the application is through an export only ODBC connection. I have been sending this data to a MySQL server temp table then run a script that selects all the data, munges the stuff that does not come out in a usable format, and reload into the live table. What I really want is to emulate or do some redirection, whichever is easier, to intercept the data on its way to the database, mung it on the fly and load it straight into the live table. To do this, I need to make the MySQL ODBC Connect driver think it is talking to the server.

Any help doing this or pointing in a good direction is much appreciated.