I frequently import .txt files to excel, always in the same format, a quite big one with 36 separate fields in 534 bytes (and separate header and trailer records, too, but that's another issue).

Is there a way to save the definition: i.e. the columns where fields split and the data type of each column so that I don't have to go through the laborious import wizard each time I want to import another instance of this file?

Posted 8 years ago