Reading / storing data from excel/CSV

Question

User640374800 posted

I am working on an ASP.NET application of framework version 2.0 and need to read in a CSV file, store the row data and do checks against database records for each row. File can contain up to 20,000 rows of data.

What would be the best approach to use for storing this data as i would also like it to also persist for the session and be as efficient as possible perhaps using the BackgroundWorker class?

Answer 1

User475983607 posted

The standard approach is importing the data using standard tools found in SQL server.   That's what databases tools are for.