The main problem is that I have no permission to copy any file to the server since the server doesnt belong to my firm.

So copying the file into a predifined folder on the server is out of the question.

Do you think loading the file and using a datareader is a good idea when you have 50,000 records in the excel file?