c# - Excel Import how would you do it? -

OK I have Excel import written. It uses excel automation to go through all the records and completes the work. But if you want to do this then how can you do it?

Will you use SSIS? Will you use detochonation? I'm really confused as the best way to get this done properly so that a client imports an import when it does not slow down the actual app for other clients.

The app I used in the past is to read Excel spreadsheet data using Olebi. The basics in this article are:

This avoids using automation, and it proved to be quite efficient.