0

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.

  • Reading between the lines: you want software that runs on Windows, and doesn't cost more than USD 1.000 (monthly subscription)? – Izzy Oct 12 '18 at 9:55
  • Depending on the software I would pay and use a different OS, ha! – Cody G Oct 12 '18 at 12:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.