View Single Post
  #1   Report Post  
strippier
 
Posts: n/a
Default Importing txt csv files into Excel greater than 65k lines

Hi,

I have to import larger text and cvs files into Excel regulary. Curently I
have to cut and paste the txt file when greater than 65k lines long. Ideally
I would like it so that the txt file is automatically cut in the first 65
lines in tab 1, next 65k lines tab 2 etc...

Is this possible as a default in the import routine of excel?