Why can I use Excel-like formulas and functions in DataLoad?
A. DataLoad doesn’t provide Excel-like functions and formulas and we don’t intend to introduce this functionality because this would just be replicating Excel. Users who need to use formulas should build their loads in Excel then transfer the data to DataLoad when the load is ready. DataLoad includes fast Excel Import functionality to help with this. This allows the user to import data from Excel in one mouse click and there is also the option to start the load as soon as the data has been imported.