Syntax

expression.Table

expression A variable that represents an OfficeDataSourceObject object.

Example
This example sets the name of the table if the table name is currently blank.

Visual Basic for Applications 
Sub OfficeTest() Dim appOffice As OfficeDataSourceObject Set appOffice = Application.OfficeDataSourceObject appOffice.Open bstrConnect:="DRIVER=SQL Server;SERVER=ServerName;" & _ "UID=user;PWD=;DATABASE=Northwind", bstrTable:="Employees" If appOffice.Table = "" Then appOffice.Table = "Employees" End If End Sub
ofv table table property

See also: