Syntax of the LOAD statement

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


>>-LOAD FROM--'filename'--+----------------------+-------------->
                          '-DELIMITER'delimiter'-'   

                                 (1)       
>--INSERT INTO--+-| Table Name |-------+------------------------>
                |                  (1) |   
                +-| Synonym Name |-----+   
                |               (1)    |   
                '-| View Name |--------'   

>--+------------------+----------------------------------------><
   |    .--------.    |   
   |    V        |    |   
   '-(----column-+--)-'

Notes:

See Identifier.

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.