FavoriteLaura Gil (Privat) posted in Data Architects (Originally asked by Laura Gil)Sep 12, 2021, 7:00 PMLaura GilHow to prepare CSV files replacing Ids from Production in a CSV from Sandbox with Access?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 #IntegrationShow MoreAdd a commentWrite a comment...BoldItalicUnderlineStrikethroughBulleted ListNumbered ListAdd linkCode blockInsert imageAttach filesLink URLCancelSave0/9000Reply
Laura GilHow to prepare CSV files replacing Ids from Production in a CSV from Sandbox with Access?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 #IntegrationShow More
