Syntax of the LOAD statement

The LOAD statement in DB-Access appends rows to an existing table of a database.

Read syntax diagramSkip visual syntax diagram LOAD FROM ' filename'DELIMITER' delimiter' INSERT INTO Table Name1Synonym Name1View Name1( column)
Notes:
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.