I have a tool that converts excel table to mysql and viceversa here is the link :
<[url removed, login to view]>
in order to make it support the newest version of MS office, I hired a VB6 developer he easily manage to make the tool convert xls and xlsx sheets of MS office 2010 n 2007 to mysql , then he disappered, I can't reach him any more, apparantly his ork but affects the other conversin way (i.e from my sql to excel which stopped orking stopped working even with old MS OFFice versions) , additionally there are some error when appending to an already existing mysql database or already existing Excel file, finally the task scheduler stop working as well (depends on windows)
I encourage you to download the full version to see exactly what I'm talking about
I am open to 3 alternatives : completing the work done by the other coder using vb6, in this case you send the source code and installation package (I use inno setup for installation) or convert the whole thing to C# and make sure all features working under c# , .net frame work
I own exclusive copyrights of the source code
Finally you will send source code + demo versin installatin package + full version installation package
if you will stick to vb6 then you must install using inno setup I have the inno installation package to update it when need .