Hi all,

Unfortunately I could not find a blog or documentation how to work with MS Access and Salesforce in cases where you want to prepare CSV files to load from a Sandbox to Production.

Say, you have Price Book Entries and you would like to prepare the template in order to replace the ID of the price book and product in a CSV containing data of the Sandbox and you want to replace those IDs with the ones in the Production environment. 

I have been working with Excel and I know there is the function VLOOKUp there but to be honest, I don't like to work CSVs with Excel. It is pretty cumbersome.

I would appreciate if someone could give some guidance how to do it with MS Access. 

#Sales Cloud  #Service Cloud  #Nonprofit  #Trailhead  #Automation  #Integration