Insert a New Record

1. Home
2. SQL
3. Insert a New Record

One method of inserting a new record is using the INSERT INTO with SQL:

INSERT INTO tblCustomer (FirstName, LastName, Age) VALUES ("Joe", "Smith", "31")

Or you can do this:

INSERT INTO tblCustomer SELECT FirstName, LastName, Age FROM tblCustomer2


insert records access sql database