Advanced Import/Export
Use the Advanced tab to perform an import/export under the following conditions:
If you are importing/exporting delimited fields, see Delimited Data. If you are importing or exporting fixed-width fields, see Fixed-Width Data.
Use the Advanced tab to import/export delimited or fixed width data, data with explicit column definitions, or data with custom field and record separators. You can also choose whether to replace a table's existing data on import.
- Choose the Advanced tab.
- Choose Delimited in the Type field.
You can specify the following values:
- Field Separator
Used between fields
- Field Start
Indicates that the next character is the first character in the field
- Field End
Indicates that the preceding character is the last character in the field
- Record Separator
Used between records
- Column Definition
Indicates whether the name of the column is included in the data file
- Delimiter at the End
Indicates whether or not records terminate with a delimiter
All these settings (except Column Definition and End Delimiter, which are either true or false) can be either single characters or strings. You can indicate a tab with "\t" and a backslash with "\\".
For example, the following settings:
Field Separator: Semicolon
Field Start: `
Field End: '
Record Separator: Empty line
Column Definition: true
Delimiter at End: false
might export the following data into the data file:
`TOY' `PRICE' `QUANTITY'
`barbie';`9.50';`0'
`beanie baby elephant';`6.50';`0'
To create or read from a data file that uses fixed-width columns instead of field separators:
- Choose the Advanced tab in the Import/Export window.
- Choose Fixed Width in the Type field.
- Set the record separator in the Record Separator field, and enter in the Null field the string that represents null values.
The grid displays the column names in the table or view and (for export) default column widths.
- If the default widths are acceptable, click OK. To change the defaults, do one of the following:
Version 5.2
[prev] | [next]