Importing .TXT file, then add header row?

R

Rick

I have a tab-delimited .TXT file that I generate every day and then
import into Excel via File | Open which calls up the Text Import
Wizard. The problem is that this text file has no header row which
I'd like the resulting .XLS file to have. The text file that I import
changes every day but the header row that should be the first row
stays the same. Can anyone think of a good way to do this? Does
Excel have some sort of 'template' feature that would allow me to use
the header row as a template file, and then I could open the text file
into that? Or ....? Thanks for any thoughts.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Project Import Error Row 1 Column 5 2
Generated text copies into another template 0
Word Template where user inputs <TITLE> and then that can be displayed in footers or headers [MAC] 0
Auto Open Macro of external .txt file based on cell reference 1
Style Header Reformatted 3
excel importing data 16
Merging from an Excel file with graphics 1
Corrupt PST 2x/week HELP! 0

Top