General Question, no code:
I have the daunting task of automating the import of mysql, ms sql and ms access into a central location. I've nailed the microsoft crap using ms sql DTS but even with mysql odbc drivers, cant seem to nail that one. The optional is that I can either import to ms sql or import to mysql but not access.
I've done some googling and found no definitive. Does anyone have advice on import/export options with regard to this?