Import data from Excel

After some research on the internet, I found a lot articles regarding "Import data from Excel to database". There are a few ways to transfer data from an Excel sheet to a table in a database, the only problem is those articles only explain them in pure technical point of view, i.e. how to make the connection to Excel sheet, etc. None of them provides a solution from application's point of view. For example, my application needs to import user's historical data from Excel sheets which is a match of the logical view of the database. Because of these, the application can not just copy each indivisual column from Excel sheet into the corresponding field of tables in the database. It needs to do something like "look up" and "calculating". This is a common task within our products. I am going to find some existing modules/code/component.