Articles tagged under excel

DTS, Excel and mixed format columns

DTS, Excel and mixed format columns I recently had a problem DTS importing an Excel spreadsheet which contained columns with mixed text and data values. After a bit of hunting around, I found an extended property IMEX=1. The IMEX=1 property forces everything to text when reading from a sour

Paul Hayman - 8,804 views