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

Back To Top
© 1998 - 2024
Version 7.21 | Advertise on this site