Microsoft Office Tutorials and References
In Depth Information
Importing data from text files using specifications
Import data from a text file
5 Select either Delimited or Fixed Width, according to the text file
format. Delimited is the more common choice. If you want to see
more advanced features of the Import Text Wizard, continue with
step 6; otherwise, click Next and proceed to step 10.
6 Click Advanced.
7 Adjust any of the advanced settings associated with the text import.
8 Click Save As to save your settings as a specification.
9 Type a name for the specification, and click OK. Click OK to close
the Advanced screen.
(continued on the next page)
TIP Import specifications allow you to set up specialized
settings for controlling how a file is imported. You can then
reload them when repeating an import process. Usually, you will not
need this extra flexibility, but if required, it can prove very useful.