In the SQL statement window you can specify the SQL syntax for updating
the record set for your table. In this section you will find a few examples
for update operations in an existing MS Access database. For more detailed
information on updating your database, see the instructions of your database
provider.
Single record append query in MS Access
INSERT INTO target [(field1[, field2[,
...]])]
VALUES (value1[, value2[,
...])
Multiple record append query in MS
Access
INSERT INTO target [(field1[, field2[,
...]])] [IN externaldatabase]
SELECT [source.]field1[,
field2[, ...]
FROM tableexpression
The INSERT INTO statement contains the following parts:
Part
Description
target
The name of the table or query to append records
to.
field1,
field2
Names of the fields to append data to, if
following a target argument, or the names of fields to obtain data from,
if following a source argument.
externaldatabase
The path to an external database
source
The name of the table or query to copy records
from.
tableexpression
The name of the table or tables from which
records are inserted. This argument can be a single table name or a compound
resulting from an INNER JOIN , LEFT JOIN , or RIGHT JOIN operation or
a saved query.
value1, value2
The values to insert into the specific fields
of the new record. Each value is inserted into the field that corresponds
to the value's position in the list: value1 is inserted into field1 of
the new record, value2 into field2, and so on. You must separate values
with a comma, and enclose text fields in quotation marks (' ').
An example of an SQL statement for
appending a single record may look as follows:
The variables %EmployeeID%, %FullName%, %Department%, %Manager%, %Location%,
%FirstName% and %Phone% will be replaced with their actual values at runtime.
