How to compare imported excel data with oracle databse ?

Question

I have 1 Excel File I want to export that Excel & check the imported excel data(multiple rows) with Oracle databse If both values are eqal then I want to add Some Values(3-4 columns value) for each rows. Is there a way of doing this ?

Baimey Rajesh · Answer

Create a .NET project to: 1. Convert your excel spreadsheet to CSV format 2. Define an external table in Oracle using the CSV file as the source. 3. Compare the external table values with the actual Oracle table using SQL within C# 4. Manipulate the result as required display results. Update data as needed. Regards 'Mark as answer' if this helped