I have an issue with the Excel Connector. I am trying to import some new leads in to Salesforce and it is failing with the above mentioned error on the Owner ID field. I am putting the full username into the field. ie. Alain Obrien in this example. This is the same format I used when importing contacts and accounts etc and I had no issues.
The bizaar bit is if I use the wizard to extract leads into Excel, it shows the owner ID as I have described above. If I change nothing, and try and use the update option, it fails with the same error. So its failing to update with the data it has just extracted.
Any assistance would be most appreciated.