Share via

How to: Open Tables (Visual FoxPro)

  • Article

To work with tables and add data to tables, you must first open them.

To open a free table

  1. On the File menu, click Open.

  2. In the Open dialog box, browse to and select the table (.dbf) file you want to open, and click OK.

    The table opens even though the table does not appear.

To display the records in the table, open a browse window. To display the table structure, open the Table Designer. For more information, see How to: View Records in Tables and How to: Edit Table Structure.

To open a database table

  1. Open the database in the Database Designer.

  2. Click the table you want to open.

  3. To open the table, perform one of the following:

    • Open a browse window for the table.

    -OR-

    1. On the Window menu, click Data Session.

    2. In the Data Session window, click Open.

      The Open dialog box appears.

    3. In the Tables in database list, click the table you want to open, and then OK.

      The table you selected opens and appears in the Data Session window.

For more information, see How to: View Records in Tables and Managing Tables in Data Sessions.

To open a table in a project

  1. Open the project in the Project Manager.

  2. In the Project Manager, expand the Data node.

  3. Select a database table or a free table:

    • To open a database table, expand the Databases node, then the database node containing the table, then the Tables node, and click the table you want to open.

      Note

      Double-clicking the table opens the Table Designer. For more information, see Creating Tables.

      -OR-

    • To open a free table, expand the Free Tables node, and click the table you want to open.

  4. To browse the table, on the View menu, click Browse. To open the table in a data session, perform the following:

    1. On the Window menu, click Data Session.

    2. In the Data Session window, click Open.

      The Open dialog box appears.

    3. In the Tables in database list, click the table you want to open, and then OK.

      The table you selected opens and appears in the Data Session window.

For more information, see How to: View Records in Tables and Managing Tables in Data Sessions.

To open a table programmatically

  • Use the USE command.

For more information, see USE Command.

See Also

Other Resources

Working with Tables (Visual FoxPro)

Managing Tables