Syntax of the LOAD statement
The LOAD statement in DB-Access appends rows to an existing table of a database.
(explicit id note010)
note010
LOAD FROM
'
filename
'
[
DELIMITER
'
delimiter
'
]
INSERT INTO
{
<Table Name>
[]
|
<Synonym
Name>
[]
|
<View Name>
[]
}
[
(
column
)
]
Element | Purpose | Key Considerations |
---|---|---|
column | The name of a column to receive data from filename | Must be a column in the specified table or view. |
delimiter | Character to use as delimiter | See Syntax for the delimiter form |
filename | Specifies the input file | None. |
This syntax diagram is only for quick reference. For details about the syntax and use of the LOAD statement, see LOAD statement.
1 See Identifier.