table_name can be a simple table name or a full path name. A table name is preferred for portability to other SQL data sources.
col_name is an optional list of column names giving the name and order of the columns whose values are specified in the Values clause. If you omit
col_name, the value expressions (
expr) must provide values for all columns defined in the file and must be in the same order that the columns are defined for the file.
expr is the list of expressions giving the values for the columns of the new record. Usually, the expressions are constant values for the columns. Character string values must be enclosed in single (’) or double (") quotation marks, date values must be enclosed in braces {}, and logical values that are letters must be enclosed in periods (for example, .T. or .F.).
select_statement is a query that returns values for each
col_name value specified in the column name list. Using a Select statement instead of a list of value expressions lets you select a set of rows from one table and insert it into another table using a single Insert statement.