Share via


How to: Add Records to Tables

Before you can store data in tables, you must add records to store the data. You can add one or more blank records to the end of a table by appending records. You can also copy records from other tables or files and append them to a table.

To add a blank record to a table

  1. Open the table in a browse window.

  2. On the Table menu, click Append New Record.

    In the browse window, a blank record appears at the end of any records in the table.

For more information, see How to: View Records in Tables.

To add a blank record after typing data

  1. Open the table in a browse window.

  2. On the View menu, click Append Mode.

When working in append mode, a new blank record appears on the following row after you type data in the previous record.

For more information, see How to: View Records in Tables.

To add a blank record to a table programmatically

  • Choose one of the following:

    • Use the APPEND command with the BLANK keyword.

    -OR-

    • To add records and specify the data to store in the new records, use the SQL INSERT command.

When you use the SQL INSERT command, you can store data in records directly by specifying text or from constants, variables, arrays, objects, and other data sources. For more information, see INSERT - SQL Command and APPEND Command.

To append records from another table or file

  • Use the APPEND FROM command or the IMPORT command.

For more information, see APPEND FROM Command, IMPORT Command, and Importing and Exporting Data.

See Also

Tasks

How to: Add Data to Records

Other Resources

Working with Records

Working with Tables (Visual FoxPro)