开发者

Compare excel data to oracle database c#

开发者 https://www.devze.com 2023-04-05 14:12 出处:网络
I have the following requirements: Read selected colu开发者_开发技巧mns(DetailsId, SentDate, Count) from excel, get data for the respective DetailsId(s) from Oracle database. Show the comparison data

I have the following requirements:

Read selected colu开发者_开发技巧mns(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


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.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号