Connect to an existing database table

When connecting to an existing database, use the ellipsis button to select the database and table name of an existing database and click Connect. The object will confirm that the database exists, and the Get from Database button on the Design tab will become available. When you click Get from Database, the table definition of the database is loaded into the object's table definition. This includes the identity or primary key column name, which cannot be modified. For more information, see SQLData object identity columns. You can define a table definition that does not include all of the columns in the database. This prevents access to columns in the database that have not been included in the table definition.