4GB CSV file won't open in excel :(
I have a 300k line 4GB CSV file that will not open in neither excel 2003 or 2010. I double click or file open it and excel will just open up a blank DB. Any advise? Won't open in notepad either. I am thinking I can open it in a better text editor and copy and paste it in quarters but there must be an easier way and this will cause problems when I save it and reopen it. Hope someone can help.
|