How to import one table data to another table

[Elin25]

How to import core_company table data which is in global application into customer_account data which is in customer service application 

[Gunjan Kiratkar · Accepted solution]

hi @Elin25 ,

I have two ways :-

1) Goto core_company table and from list view change the class of company as 'Account' and Customer as 'true'.

Record will automatically create in account table.

2) Export Data from core company table in excel formate and then import the data into customer_account table using transform map.

[Gunjan Kiratkar · Accepted solution]

hi @Elin25 ,

I have two ways :-

1) Goto core_company table and from list view change the class of company as 'Account' and Customer as 'true'.

Record will automatically create in account table.

2) Export Data from core company table in excel formate and then import the data into customer_account table using transform map.

[Elin25 · Accepted solution]

Thanks for quick response

The first way is really great option we have to do for more than 90000 records so it is bit of complexity 

And 2nd way Here we don't want to export data from instance so please suggest any alternate way thank you 

[Gunjan Kiratkar]

Hi @Elin25 ,

For 1st option you can create fixed script and run to update the data.

[Elin25]

Could you please brief more how to proceed on fixed script

Thank you