Connection XML

<connection id="5" name="Text" type="6" refreshedVersion="3"
  background="1" saveData="1">…
  <textPr codePage="437" sourceFile="E:\ …\Text.txt">
    <textFields count="3">
      <textField type="text"/>
      <textField position="5"/>
      <textField type="skip" position="10"/>
    </textFields>
  </textPr>
</connection>

<connection> defines the connection

• @type value of 6 indicates that this is a text import type of connection.

<textPr> expresses properties which are specific to text import connections.

• @codePage value of 437 indicates that the text file is using the IBM PC (OEM) code page 437 character set.

• @sourceFile indicates where the file is located.

<textFields> expresses information about the particular fields in the text file.

• @delimited value of 1 (default) indicates that the text is delimited (variable length). Since this example uses the default value, it is not saved as part of the connection information.

• @type indicates the data type (user-specified) of the particular field.

• @position indicates the starting position of the field for fixed-width fields.

• @thousands specifies the thousands separator character (not in this example, but of enough interest to mention).

• @tab, @space, @comma attributes with values of 1 would flag these characters as delimiters (not in this example, but of enough interest to mention).