Insert Into SQL
AKA the Access Append Query
Insert into SQL command is SQL Query statement employed to append new records to a table in your relational database. The Access insert into query is synonymous with the append query.
The basic syntax of the SQL Insert Into query for a single record is:
Insert Into TableName (FieldName1, FieldName2) Values (Value1, Value2);
For multiple records gathered from other tables or external sources the Access insert into query is slightly different:
Insert Into TableName (FieldName1, FieldName2) Select FieldName1, FieldName2 From TableName;
The full syntax of the insert into query statement from Microsoft Access help is:
INSERT INTO target [IN externaldatabase] [(field1[, field2[, …]])] SELECT [source.]field1[, field2[, …] FROM tableexpression;
Note: The ending semicolon is a required component of all SQL statements.
Now the insert into SQL query with real column and table names for a single row:
Insert Into M_Employees (Emp_ID, Emp_Name, Emp_Start_Date) Values (00212, “Joseph Dean”, #01/02/06#);
Note that text values are bounded by quote marks and date values are bounded by pound signs in the insert into query.
Multiple row inserts using the select statement alternative – a variation of the insert into query.
Insert Into M_Employees (Emp_ID, Emp_Name) Select Emp_ID, Emp_Name From MyLinkedSpreadsheet Where Emp_Status=”New”;
Note that we restrict the number of records to only those records with a status value of ‘New”.
More SQL Append Query Examples:
Docmd RunSQL Access SQL Append Query
Concatenate Records Insert Into Query
MS Access 2000 Through Access 2016 & Office 365
Development in Microsoft Access, Microsoft SQL/Server and Azure
See our SQL/Server Development and Access Migration Tutorials
Microsoft Office VBA, MS Access 2003, 2007, 2010, 2013, 2016