Black Box ICOMP, User Manual

Page: 23 / 92

Copyright (c) 2009 - 2012 Black Box Corporation
724-746-5500 | blackbox.com 23
Building a Connection
2.3.6.2 Format Settings
To allow for a variety of text file formats, the way the iCompel Data Engine handles text files can be finely controlled.
The following settings are available:
Use the following settings . The setting will use the specified separator, column headings settings and date
and time format (if applicable). This is the default setting.
Use custom schema information settings . The specified settings will be used. This option provides very
fine grained controlled over the file format. Please refer to Schema.ini File (Text File Driver) in the Microsoft
®
documentation for further information. Please note the following:
The filename section must not be specified.
The ColNameHeader entry should be specified, and if set to false, then the fields must be specified in
the Settings , as described in the 'Specifying the Fields' section of the above web page.
The CharacterSet entry should be specified