Hi,
Please I need help to find the best way to approach the following problem.
In our company we are daily receiving one or more excel sheet files. Each file contains an average of 5000 to 25000 phone number stored from top to bottom with no sorting.
We have to do some calculation manually against these files. The total of the entire phone numbers, which phone numbers are duplicated and the total number of times of the duplication for each one.
It's hard for everybody to do the calculation manually and it consumes a lot of time.
What about reading the data directly and programmatically from excel sheet and then saving them into access or dataset and then doing the calculation?
What about LINQ? Moving the data to an array and then doing the calculation using LINQ.
Thanks.