|> Home > Documentation > Latest documentation > Interchange tags > import|
Import one or more rows into a database table.
or similarly with positional parameters:
Import one or more rows into a database table. The type is any of the valid Interchange delimiter types, with the default being defined by the setting of the DELIMITER. Non-SQL tables must already be defined within the Interchange configuration, as they cannot be created on the fly. If you need that, it is time to use SQL.
The type of LINE and continue setting of NOTES is particularly useful, as it allows you to name your columns and not have to remember the order in which they appear in the table. The following two imports have an identical effect:
The code (table key) must always be present, and is always named code. If you do not use NOTES mode, you must import the fields in the same order as they appear in the ASCII source file.
The [import]...[/import] region may contain multiple rows If using NOTES mode, you must use a separator, which by default is a form-feed character (^L).
Any existing table defined in the Interchange configuration.
"TAB", "PIPE", "CSV", "%%" or "LINE".
"NOTES", "UNIX" or "DITTO".