I have a text file from CDR log and need to manipulate the data.
Problem is, EXCEL only cater until 65000 lines. How to overcome this? How to export the whole text file to Excel?
2007-02-22 13:31:51 · 3 answers · asked by yana_ano 2 in Computers & Internet ➔ Software
Your best bet may be to use MS-access. Access will allow more than 65000 records. you can also query and create reports.
Another option would be to use MS-SQL or MySQL.
Just like MS-Access--with a DB solution you can query your data and import into products like Crystal Reports or back into Excel in smaller pieces based on your query
2007-02-22 13:40:42 · answer #1 · answered by Jeffrey F 6 · 1⤊ 0⤋
Try Excel 2007. Its free download for now.
2007-02-22 18:28:47 · answer #2 · answered by unnga 6 · 0⤊ 0⤋
break it up into smaller files, and import them into multiple sheets.
2007-02-22 13:35:23 · answer #3 · answered by Richard H 7 · 0⤊ 0⤋