Splitting a huge text file

[Jordan12]

Hi all

I am hoping that for some help please, new in the coding world. I have a huge text file +- 2 mil lines, is there perhaps a way that I could split the text file in order for me to import into excel. I had a look at the google but nothing that works for me or I just don't get it I think I am a bit out of my depth here. Any help would be appreciated.

Regards
Jordan

 

[Stiuart_W]

Well you could obviously create 2 copies of the text file. Open and delete the FIRST millions lines and then save. Then open the other file and delete the SECOND million lines and save. That will leave you with 2 huge files.

Personally you should be exploring other ways to manipulate this data rather than Excel which is going to struggle with that amount of data unless you have a serious computer.

I'd be looking at Access as a minimum

 

[steve the fish]

Depends on your version of excel and what you need to do with the data but power pivot will accept that many rows.