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?
|