Add New Record To Table Excel. The buttons click event calls a procedure named addNewRow. Add new record to end of table In you control source field on your form put the following with you fields.
Click the Browse button and find the spreadsheet file that contains the data to be imported. Create a query to select the records to copy. Then click the OK button.
Use your mouse to select the cells that contain the information for the table.
The second is to add many records at a time. How do I insert a record into an SQL table. Part 1 will show you how to setup the table edit values and save changes back to a datasource. On the Create tab in the Queries group click Query Design.
