QueryTableClass Members 

The following tables list the members exposed by the QueryTableClass type.

Public Constructors

Top

Public Properties

	Name	Description
	AdjustColumnWidth
	Application
	BackgroundQuery
	CommandText
	CommandType
	Connection
	Creator
	Destination
	EditWebPage
	EnableEditing
	EnableRefresh
	FetchedRowOverflow
	FieldNames
	FillAdjacentFormulas
	HasAutoFormat
	ListObject
	MaintainConnection
	Name
	Parameters
	Parent
	PostText
	PreserveColumnInfo
	PreserveFormatting
	QueryType
	Recordset
	Refreshing
	RefreshOnFileOpen
	RefreshPeriod
	RefreshStyle
	ResultRange
	RobustConnect
	RowNumbers
	SaveData
	SavePassword
	SourceConnectionFile
	SourceDataFile
	Sql
	TablesOnlyFromHTML
	TextFileColumnDataTypes
	TextFileCommaDelimiter
	TextFileConsecutiveDelimiter
	TextFileDecimalSeparator
	TextFileFixedColumnWidths
	TextFileOtherDelimiter
	TextFileParseType
	TextFilePlatform
	TextFilePromptOnRefresh
	TextFileSemicolonDelimiter
	TextFileSpaceDelimiter
	TextFileStartRow
	TextFileTabDelimiter
	TextFileTextQualifier
	TextFileThousandsSeparator
	TextFileTrailingMinusNumbers
	TextFileVisualLayout
	WebConsecutiveDelimitersAsOne
	WebDisableDateRecognition
	WebDisableRedirections
	WebFormatting
	WebPreFormattedTextToColumns
	WebSelectionType
	WebSingleBlockTextImport
	WebTables

Top

Public Methods

(see also Protected Methods )

	Name	Description
	add_AfterRefresh
	add_BeforeRefresh
	CancelRefresh
	Delete
	Equals	(inherited from Object )
	GetHashCode	(inherited from Object )
	GetType	(inherited from Object )
	Refresh
	remove_AfterRefresh
	remove_BeforeRefresh
	ResetTimer
	SaveAsODC
	ToString	(inherited from Object )

Top

Protected Methods

	Name	Description
	Finalize	(inherited from Object )
	MemberwiseClone	(inherited from Object )

Top

Public Events

	Name	Description
	AfterRefresh
	BeforeRefresh

Top

See Also

Reference

QueryTableClass Class
Microsoft.Office.Interop.Excel Namespace