File (Output)

To get to this dialog in TextConverter, click the Set Output DB Table button () in the upper right pane (the Output Pane) of the user interface, then click the File tab.

The "File" pane of the database connectivity dialog provides database access to flat files and file based database tables. Use this tab to navigate the file system to connect to DBase, FoxPro, MS Access, Excel, text files, etc. Double click on a folder in the file system tree (left part of the pane) to browse the list of available database resources for that folder. Change the file type to narrow down the visible database types (*.dbf, *.csv, *.mdb, etc. ). In the case of flat database tables like DBase or CSV, selecting a table in the file list will display its structure in the field list on right side of the pane.  This feature allows you to make sure that you are looking at the right table without even opening it.

For positional or fixed length output, when you set the Output Data Source, choose “Text Files” from the file type drop down.  An option will appear on the right for “Positional Output”

Picture 1. When working with file-based databases like MS Access or Excel, selecting a database name in the file list will display a list of tables located in that database. Select a table from the table list to connect to it:

Picture 2. The data connectivity dialog is used for two different tasks:

- to open an existing data source

- to connect to a new data source, which will be created as a result of a future process (tool specific).

In the first case, the "Set" button reads as "Open" and you can not connect to a nonexisting data source.  In the second case, you can type in a new table name, which will be used in the future to create a new table. Click "Set" (or "Open") when you have selected your data source.

The image below shows where you can control (check or un-check) the "First Row Has Column Header" in the set output data source dialog.  This allows you to include a header in the first row of the output file using the field names from the output dictionary.