Application.QueryDBEx

This function queries a DB with SQL using a connection string and flag to specify using advanced query builder.

Syntax Parameters Return Value 
Function Application.QueryDBEx( _
    SQL As String, _
    ConnectionString As String, _
    Optional AQB As Boolean = False, _
    Optional CaseNo As Integer = 0, _
    Optional VarNo As Variant = 0, _
    Optional Parameters As Variant = 0, _
    Optional Prompt As Boolean = False) As Spreadsheet
  • SQL [in]

Type: String

  • ConnectionString [in]

Type: String

  • AQB [in,optional]

Type: Boolean

Default value: False

  • CaseNo [in,optional]

Type: Integer

Default value: 0

  • VarNo [in,optional]

Type: Variant

Default value: 0

  • Parameters [in,optional]

Type: Variant

Default value: 0

  • Prompt [in,optional]

Type: Boolean

Default value: False

Spreadsheet