I have a bunch of data I want to import into a custom object. I need these records to have a look up to the Account.
The Account has an External ID which is also present in the data I'm importing. Can I create child records referencing the External ID and not the Account ID?
This will be a fairly frequent data import so I would rather not have to do any manual matchup in Excel to get the Account ID.
The only option I can think of is to import with External ID listed in my custom Object and run a batch Apex job to do the referencing and populate the lookup field with the Account ID.