Hi all,
I have a requirement of importing the excel file to database. When the user upload an excel file in import it should create new data in 3 different tables.
For example, in the excel file the data present is based on deals and each deal can have one or more number of loans and the deal will be having some amount values. So when the user upload a file it should update deals table, loans table an other table which contains of amount data of the deal.
Thank you.
Discussion posts and replies are publicly visible
use 'Parse Excel to CDT' smart service. Map corresponding columns from excel into the table CDT you have , check relationships and insert or update data.
Hey lakshmikanth ,
I have tried but there are some date fields in the excel and when the file is uploaded the date fields are updating as null.
Any Idea what to do here.