Converting Pre-95 Excel To MSSQL Using CLI Tools Or Libraries.
Older Excel files can't be read by Apache POI. Export to CSV/TSV & bulk import or use Spreadsheet CFML to stream data into memory. Alternatively, use Total Excel Converter CLI for conversion.
Q: How do you solve a problem you don't know how to solve? A: Turn it into a problem that you do know how to solve. How can I import data to a MSSQL Server from an "Pre-95" Excel 2 Worksheet XLS file? Reading data from an Excel 97 XLS or XLSX file is supported. You can use the third-party Spreadsheet CFML library (personally preferred) or use package manger to install the built-in cfSpreadsheet. If you encounter an older Excel file, these java-based solution aren't much help. Apache POI (used by cfSpreadheet & Spreadsheet CFML) can't read older Excel files. You'll need to first ex...