how to open excel file size more than 2 GB

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?

thanks.
LVL 3
excelismagicAsked:
Who is Participating?
 
Rob HensonConnect With a Mentor Finance AnalystCommented:
Do you have MS Access? That does not have a limit to the number of rows of data.

If you import into access you could then set queries or filters to extract data in chunks or even just leave in Access and then use that as the data source for work in Excel.
0
 
Zaheer IqbalTechnical Assurance & ImplementationCommented:
Have you tried to exporting xlsx instead of xls ?
0
 
nathanielConnect With a Mentor IT ConsultantCommented:
try generating in .csv format from ERP or if you are familiar with Access you can import the excel file there (in External Data menu) and manipulate it thru the Query, like what Rob is suggesting.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.