Do

Step 3 of the Wizard is where you actually identify the field types. In our case, we left all fields as General except for the first field, which was marked as a date in MDY (Month, Day, Year) format (see Figure 2.12). This is represented in code by the FieldInfo parameter.

Figure 2.12

The third step of the Text Import Wizard is fairly complex.The entire FieldInfo parameter of the OpenText method duplicates the choices made on this step of the Wizard.

If you would happen to click the Advanced button on Step 3 of the Wizard, you have an opportunity to specify something other than the default Decimal and Thousands separator, plus the setting for Trailing Minus for negative numbers (see Figure 2.13). Note that the macro recorder does not write code for DecimalSeparator or ThousandsSeparator unless you change these from the defaults. The Macro Recorder does always record the TrailingMinusNumbers parameter.

Figure 2.13

TheTrailingMinus Numbers parameter comes from this Advanced Text Import Settings. If you had changed either of the separator fields, new parameters would have been recorded by the macro recorder.

Figure 2.13

TheTrailingMinus Numbers parameter comes from this Advanced Text Import Settings. If you had changed either of the separator fields, new parameters would have been recorded by the macro recorder.

0 0

Post a comment