View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dan dan is offline
external usenet poster
 
Posts: 866
Default Text Import Wizard

How can I limit the number of lines the Wizard imports? I.e. want to limit
the import to the first 53 lines of a file that has 300 lines.

Want to import the first "XX" set of lines in a Delimited format (since this
is the header), then the other lines with the Fixed Width format.

Thanks