Parameters.Add Method

Creates a new query parameter. Returns a Parameter object.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Function Add ( _
    Name As String, _
    iDataType As Object _
) As Parameter
'Usage
Dim instance As Parameters
Dim Name As String
Dim iDataType As Object
Dim returnValue As Parameter

returnValue = instance.Add(Name, iDataType)

Parameter Add(
    string Name,
    Object iDataType
)

Parameters

• Name
  Type: System.String

  Required String. The name of the specified parameter. The parameter name should match the parameter clause in the SQL statement.

• iDataType
  Type: System.Object

  Optional Object. The data type of the parameter. Can be any XlParameterDataType constant.

Return Value

Type: Microsoft.Office.Interop.Excel.Parameter

See Also

Reference

Parameters Interface

Parameters Members

Microsoft.Office.Interop.Excel Namespace