Append method (ADOX Columns)

Applies to: Access 2013, Office 2013

Adds a new Column object to the Columns collection.

Syntax

Columns. AppendColumn [,Type] [,DefinedSize]

Parameters

Parameter Description
Column The Column object to append or the name of the column to create and append.
Type Optional. A Long value that specifies the data type of the column. The Type parameter corresponds to the Type property of a Column object.
DefinedSize Optional. A Long value that specifies the size of the column. The DefinedSize parameter corresponds to the DefinedSize property of a Column object.

Note

An error will occur when appending a Column to the Columns collection of an Index if the Column does not exist in a Table that is already appended to the Tables collection.