+ Start a Discussion

Data import

Hi All,


I have data in two access tables that needs to be transferred to a Salesforce object. Two tables are related but can be mapped to single object in Salesforce. How to import two related tables to a single Salesforce object? Could any one please let me know the steps? I greatly appreciate your help.

Ritesh AswaneyRitesh Aswaney

You could either :

1) Produce One flat file outside of salesforce with data from the two tables aggregated and upload into Salesforce via DataLoader


2) Follow a 2-step upsert into Salesforce. Get two csv extract files from your external system. You would need to define an External Id field for the object in salesforce for this. In Step 1, Upsert from the first csv file using DataLoader. In Step 2, Upsert from the second csv file. In each case match on the External Id field, so that the upserts can be de-duped by the external id.