Loading

How to compare imported excel data with oracle databse ?

Sanket Jain

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 ?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Baimey Rajesh11y ago
Create a .NET project to:

1. Convert your excel spreadsheet to CSV format
2. Define an external tablein 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
0