After you install the April 4, 2017, update for Excel 2016 (KB3178719), the following Get & Transform features are updated in Microsoft Excel 2016:
-
Split Column by Delimiters: Automatic detection of delimiter characters
-
Combine Binaries: Specification of a sample file for a combine action
-
DB2: Package Collection setting
