To insert new rows of data into a database table, use the insert statement. For example, this statement adds a row to the Personnel table, transferring the contents of simple fields Lname, Fname, and Empnum to table columns last, first, and empnum, respectively:

Appending values to a database table from a table field generally involves using the insert statement along with the unloadtable statement, which is described in Processing an Entire Table Field or Array with Unloadtable and unloadtable Statement--Loop Through Rows and Execute Statements. Unloadtable can also be used with arrays.