Constructing an SQL INSERT Command

To construct an SQL INSERT command using the SQL Wizard:

1. From the Record Source tab of the Data Control OLE Properties dialog box, click Run SQL Wizard. The Select Operation dialog box appears.
2. In the Select Operation dialog box, click SQL Insert. The Select Table to Insert Into dialog box appears.
3. Select one or more tables for your statement, then click Next. The Select Values to Insert dialog box appears.
4. Insert values into one or more table columns for your statement, then click Next. The Finish dialog box appears.
5. Optionally, edit the statement. Click OK to return to the Data Control OLE Properties dialog box.

See Also