Read excel data by using the store procedure

Question

Here is the Problem 
 
 There is a excel which having the data 
 i want to create a store procedure that read the excel data and save this data to temp table. 
 after that it save the data to main table. 
 and after save into the main table, SP now truncate the temp table. 
 
 can anyone write the code of SP and tell me how to use this SP in process model 
 
 Thanks

Soma · Answer

First import the data from excel file to a temporary table using " Import Excel to Database" smart service. 
 Create a stored procedure that has the SQL statements that takes the data from temp table to main table (You can also use an Appian process to do that) 
 At last use the truncate statement in Stored Procedure to drop the contents in the temp table. 
 In the process model call the stored procedure using Execute Stored Procedure smart service

Shubham Aware · Answer

ankits7238 Stored Proc can't read data from excel in appian. You have to follow mentioned steps by Soma with data validation flow to avoid errors.