I have a text file that contains 5 million records. I want to import the file to excel. but the row limit for excel is around 1 million. Thus i need to split the record into different sheet so that i could all the records in one excel .
I have following code which display the data for around...