How to load data to table from excel

Nana5 · ‎12-11-2015

Hi Friends,

How i can upload the data to table from excel.

Thanks

Rushit Patel2 · ‎12-12-2015

Hi Prakash,

if you dont understand wiki follow below steps. i am assuming that u dont already have transform map for that destination table. if u have then use that

go to system import sets-->load data module
enter table name..chose file(.xls file) make sure 1st row in excel match fields in your destination table.so it will automap.
then click on create transform link
give it a name,select destination table(table in which u want to upload data)
click on auto map matching fields..if required fields do not match then click on mapping assist and match fields.
set colesce true to any one field from related list. it will be your unique field
click transform

Let me know if u face any problems.

(please mark helpful/correct/like if it helps)

Regards,

Rushit Patel

View solution in original post

Jha · ‎01-15-2022

Hello Tanaji,

As checked the shared link is not working anymore .

AJ14 · ‎11-01-2019

Would this also be the steps for London and also for New York?