I download files generated by our company ERP reporting system, i downloaded a file which has more than 2 million rows data. the file downloaded in .xls file but when i open it excel cannot open it, because it goes beyond the limit that excel can handle. even excel 64bit cannot help here.
what i need is to be able to change the file format to text or some other type that i can import this to any other program and then split the file in chunks that can be opened.
can anyone please share how to handle this issue?
what tool or software should i use to accomplish what i need to achieve described above?