I would hope this tool would let me select columns for import from excel and then rigidly apply data type rules, allow custom conversion functions, and provide some sort of "workflow" that retains the history of parallel and sequential actions.
Currently I am using Microsoft power query... but I fear what I would use besides custom C#.NET programming if I had to do larger datasets.
Found this link, Excel to SQL mapping tool
But... also no answers. I'm under the impression this software doesn't exist. Usually the import tools in database software are not very forgiving on data format expectations.