How to: Open Tables (Visual FoxPro)
To work with tables and add data to tables, you must first open them.
To open a free table
On the File menu, click Open.
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
Open the database in the Database Designer.
Click the table you want to open.
To open the table, perform one of the following:
- Open a browse window for the table.
-OR-
On the Window menu, click Data Session.
In the Data Session window, click Open.
The Open dialog box appears.
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
Open the project in the Project Manager.
In the Project Manager, expand the Data node.
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.
To browse the table, on the View menu, click Browse. To open the table in a data session, perform the following:
On the Window menu, click Data Session.
In the Data Session window, click Open.
The Open dialog box appears.
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.