Compare excel data to oracle database c#

Question

I have the following requirements:

Read selected columns(DetailsId, SentDate, Count) from excel, get data for the respective DetailsId(s) from Oracle database. Show the comparison data from the excel and database in a grid (MVC).

If the data matches do nothing, if there is a mismatch update some database columns with data in the excel.

Any suggestions how this can be done

Thanks

There are a variety of ways, built into dotnet, to read excel spreadsheet files. The rest of this is typical application programming. — O. Jones
– O. Jones, Commented Sep 15, 2011 at 11:50

DCookie · Accepted Answer · 2011-09-15 15:00:27Z

1

Convert your excel spreadsheet to CSV format, define an external table in Oracle using the CSV file as the source, then compare the external table values with the actual Oracle table using SQL within C# and display results as required. Update data as needed.

answered Sep 15, 2011 at 15:00

DCookie

43.7k11 gold badges88 silver badges93 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Compare excel data to oracle database c#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related