Contains information about the data source of a query.
Element |
Description |
QueryType |
Specifies the type of data source. |
CommandText |
Contains the ODBC or OLE DB command string used to query data from a data source. |
CommandType |
Contains the type of command specified. |
Maintain |
Specifies whether a connection is kept open. |
Connection |
Contains the connection string of a data source, or the location of the data for a chart. |
Maintain |
Specifies whether a connection is kept open. |
Connection |
Contains the connection string of a data source, or the location of the data for a chart. |
CommandText |
Contains the ODBC or OLE DB command string used to query data from a data source. |
CommandType |
Contains the type of command specified. |
DoNotJoinDelimiters |
Specifies whether consecutive delimiters are treated as one when importing data from a Web page. |
NoTextToColumns |
Specifies whether text data is converted to columns when importing data from a Web page. |
DisableDateRecognition |
Contain a Boolean value indicating whether Excel should force strings that look like dates to be imported as text. |
EnableRedirections |
Specifies a boolean that allows for web pages that are constructed a certain way for an Excel Web Query to get data directly from the data source rather than just the static information in the table on the web page. |
EditWebPage |
Contains an HRef attribute that specifies the URL of a Web page to be used as the data source when EnableRedirections is set to true. |
RefreshedInXl9 |
Contains a Boolean value to indicate whether the query table was last refreshed in Microsoft Excel 2000. |
EntirePage |
Specifies whether the entire page is imported during a Web query. |
HTMLFormat |
Specifies the amount of formatting imported into a query table from a Web page. |
URLString |
Specifies the URL of a Web page used as the data source. |
WebPostString |
Contains the POST method parameters of a Web query. |
RefreshInfo |
Contains refresh information for the query. |
TextWizardSettings |
Contains the Text Import Wizard settings. |
HTMLTables |
Specifies the HTML tables on a Web page that are imported into a query table. |
UseSameSettings |
Specifies whether the same text import options are used for an entire section on a Web page. |
Query97 |
Specifies whether the query was created in Microsoft Excel 97. |
DoNotPromptForFile |
Specifies whether to prompt the user for the name of a text file when performing a text file query. |
LocalConnection |
Specifies the text that defines the connection to the local cube slice on the client computer. |
SourceConnectionFile |
Contains the name of thefile where the data source connection settings came from when the query table or PivotTable view was created. |
SourceDataFile |
Contains the name of source data file (such as an .mdb file) from which the data for the PivotTable view was originally retrieved. |
RobustConnect |
Contains values that specify how data connections are to be handled when data is refreshed. |
RefreshTimeSpan |
Contains an integer value specifying the number of minutes until the first data refresh and subsequent refreshes when automatic refreshes are enabled. |
VersionLastEdit |
Reserved for future use. |
VersionLastRefresh |
Reserved for future use. |
VersionRefreshableMin |
Reserved for future use. |
Parameter |
Contains information about a query parameter. |