I often find that Excel files contain special characters that must be cleansed before or during processing. In the cases where the data must be…
Month: September 2018
This is another trick gleaned from exploring data to be imported to a Data Warehouse from an Excel spreadsheet. Sometimes we are provided data in…