Question

An administrator needs to update 150,000 existing Account records by matching on a custom External ID field and inserting any records that don't yet exist. The source file also contains records for a custom object that has no import support in the point-and-click tool. Which tool and operation should the administrator use?

Accepted Answer

Data Loader using the Upsert operation, matching on the External ID field

Answer

Data Import Wizard using the Update operation, matching on the External ID field

Answer

Data Import Wizard using the Add new and update existing records option

Answer

Data Loader using separate Insert and Update operations run sequentially