Part III: More-Advanced Access Techniques
622
- Select Fixed Width and click Next.
The next screen of the Import Text Wizard (shown in Figure 17.14) appears.
FIGURE 17.14
The Import Text Wizard screen for fixed-width text files- Adjust field widths as needed (see Figure 17.15).
Access guesses at the best breaks to use for fields, based on the most consistent spacing
across rows. In this case, the field breaks are very consistent. If necessary, however, use
the mouse to grab a dividing line and move it left or right to change the width of fields in
the file.
FIGURE 17.15
Access guesses at field breaks in the fixed-width file.