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 - 2017 psacake.com | My3C's

Version 7.2 | Advertise on this site