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 psacake.com
Version 7.21 | Advertise on this site