开发者

Compare excel data to oracle database c#

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜