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

somasundaram.d · 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

Sign up

Login with SSO

Login to the community

Login with SSO