- Clicking Next brings up a screen where you can adjust the column widths, as shown in
Figure 10.4.
FIGURE 10.4
Adjusting columns in a fixed-width file.- The next screen, shown in Figure 10.5, lets you specify field names if they are lacking
in the text file (this is often the case with files exported from mainframes). The figure
shows the first field (originally named ProductNumber, and given a default field name of
Field1 by the wizard) being renamed with its original name. You can also change the data
type of the field, if necessary; for example, making a Text field containing numeric data a
Long Integer or Currency field, or a Text field containing date/time data a Date/Time
field. - The screen in Figure 10.6 lets you add, select, or not specify a primary key; in this case,
because the data will be appended to a table that has an AutoNumber field, the “No pri-
mary key” option is correct. - You will next see a screen that lets you enter the name of the target Access table.
Part II Writing VBA Code to Exchange Data between Office Components