Importing Text

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

I am trying to set up a macro to import a delimited text
file. It is delimited with | (the piping symbol). It asks
for a specification name but I don't understand what it
means - the help file doesn't help. If I click on the down
arrow it is also blank. How do I import the file?

Thanks,

Daniel
 
1. Use File|Get External Data|Import
2. Select the text file to be imported
3. A popup window will open. Somewhere in that window (depending on
version), you will see a command button labeled "Advanced". Click this
button
4. The next window allows you to set delimiters, etc., and most important
to save the specification with a name.


hth,
 
Back
Top