I exported an Account from one sandbox with the intention of inserting it into another (i.e. I am copying data between orgs). This is a simple CSV file with two lines: the first has the field names (header row), the second is the data for the Account.
When data loader attempts to load it, the record errors out because Name is missing. However, it is there in the fourth field, plain as day. When I select the CSV file, data loader shows the fields and Name is there.
Header:
"ID","ISDELETED","MASTERRECORDID","NAME",...
Data:
"","false","","Test Data",...
How do I resolve this error? Is it procedural on my part? Bug in data loader? Is there a better way of copying data between orgs?