xsevensinzx (5/19/2016)

---

sestell1 (5/18/2016)

---

Darn, it looks like that uses the MS Office API to connect to the workbook and do the conversion. I was hoping for a command-line utility that does not require Office to be installed, and doesn't use the ACE provider with its infuriating data type guessing behavior.

Python?

Use Python to load the Excel file via Pandas module, transform & clean it in Pandas data frames and then output the results in any format you want including CSV. The Python script becomes a command-line utility that can run on Windows if you install Python 2.7 or greater in the environment. Then use SSIS/SQL to execute that Python script.

http://pandas.pydata.org/pandas-docs/stable/generated/pandas.read_excel.html

If you need examples, let me know.