I’ve just started exploring Excel 2016. As one of the tentpole applications for the new Office 2016, it has a raft of new features for lucky upgraders. Take a closer look with me and see what you ...

A small ETL solution that imports data from Excel files into SQL Server tables. Connection details are stored in project parameters (never hard-coded) to keep credentials secure. I will attach a SQL ...

Taking a look at how marketers can unlock the power of data analysis using traditional tabular software and data languages. Marketers would like to unlock the power of data — but with so many ...

Excel to SQLite simplifies the process of importing Excel data into SQLite databases. It provides automatic schema detection, data transformations, validation rules, and includes an intelligent ...