Add data to the table

Note

To add data to your table, you import a text file of tab-separated values. Importing the file quickly adds 60 rows of data.

Typically you create a form to add data to the database. In the form tutorial you saw how to add data using a form.

  1. Display the pop-up menu for contact1 and select Edit Data>Grid.

    Shown is the Database Painter with the contact 1  selected in the tree view at left and a pop up menu with Edit Data > Grid selected

    The Results view shows column headers but no data. This view lets you view, add, modify, and delete data.

    Shown is the Results tab page at the bottom of the Database Pointer screen. It displays the column headers I D, Last Name, First Name, and Job Role, but no data under them.
  2. Select Rows>Import from the menu bar.

    The Select Import File dialog box displays. You might need to change to the Tutorial folder, which contains the file you use.

  3. If necessary, change to the Tutorial folder.

    Double-click the contact.txt file.

    InfoMaker imports the data into the Results view (the data is not yet in the database).

    Shown is the Results view from the bottom of the Database Pointer screen. It displays the column headers I D, Last Name, First Name, and Job Role and several rows of data under them.
  4. Select Rows>Update from the menu bar.

    This adds 60 rows of data to the database. To be sure that the data is in the database, you retrieve it from the database.

  5. Select Rows>Retrieve from the menu bar.

    InfoMaker retrieves all the contact data from the database and displays the data in the Results view.

  6. Select File>Close from the menu bar.

    This closes the Database painter.

You have created a new database table, complete with extended attribute information and data.