I want to load an excel file into database and update the row level status (in file) with results of upload (Sccess or the Error ).

My data looks like this

AccountId Ticker Qty UploadedTradeId Upload Status
1 IBM 1,000
2 GE 2,000
3 MSFT -500

I want to load this in DB and fetch the 'UploadedTradeId' (the Identity column for table) or the error ( like foreign key violation) and update the excel file back with these.

Name:  tradeUpload_2.jpg
Views: 31
Size:  6.9 KB