Posted: Tue Nov 10, 2009 9:20 am Post subject: Re: MS Access to Salesforce useing Upsert
I have a table in Salesforce that has an external ID I need to update or creat new records from Acess,
but Im not sure of how that will look What do I need to join to the Update connector????
Your datamap will look like:
MS Access - Transform - SFDC
1. Configure your MS Access connector.
2. Configure your SFDC connector in Update mode and choose your External ID field against which you would update your records.
3. In Transform you need to map all the fields between two tables that you would like to update/upsert/insert. Do not forget to map Id filed from MS Access to External Id filed from SFDC.