Documentation for Microsoft Office 2003 Reference Schemas
Definition Type: ComplexType
Name: QTQuerySourceType
Namespace: urn:schemas-microsoft-com:office:excel
Containing Schema: excel.xsd
Abstract
Documentation:
Contains information about the data source of a query.
Collapse XSD Schema Diagram:
Drilldown into Parameter in schema excel_xsd Drilldown into VersionRefreshableMin in schema excel_xsd Drilldown into VersionLastRefresh in schema excel_xsd Drilldown into VersionLastEdit in schema excel_xsd Drilldown into RefreshTimeSpan in schema excel_xsd Drilldown into RobustConnect in schema excel_xsd Drilldown into SourceDataFile in schema excel_xsd Drilldown into SourceConnectionFile in schema excel_xsd Drilldown into LocalConnection in schema excel_xsd Drilldown into DoNotPromptForFile in schema excel_xsd Drilldown into Query97 in schema excel_xsd Drilldown into UseSameSettings in schema excel_xsd Drilldown into HTMLTables in schema excel_xsd Drilldown into TextWizardSettings in schema excel_xsd Drilldown into RefreshInfo in schema excel_xsd Drilldown into WebPostString in schema excel_xsd Drilldown into URLString in schema excel_xsd Drilldown into HTMLFormat in schema excel_xsd Drilldown into EntirePage in schema excel_xsd Drilldown into RefreshedInXl9 in schema excel_xsd Drilldown into EditWebPage in schema excel_xsd Drilldown into EnableRedirections in schema excel_xsd Drilldown into DisableDateRecognition in schema excel_xsd Drilldown into NoTextToColumns in schema excel_xsd Drilldown into DoNotJoinDelimiters in schema excel_xsd Drilldown into CommandType in schema excel_xsd Drilldown into CommandText in schema excel_xsd Drilldown into Connection in schema excel_xsd Drilldown into Maintain in schema excel_xsd Drilldown into Connection in schema excel_xsd Drilldown into Maintain in schema excel_xsd Drilldown into CommandType in schema excel_xsd Drilldown into CommandText in schema excel_xsd Drilldown into QueryType in schema excel_xsdXSD Diagram of QTQuerySourceType in schema excel_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code: 
<xsd:complexType name="QTQuerySourceType">
    <xsd:annotation>
        <xsd:documentation>Contains information about the data source of a query.</xsd:documentation>
    </xsd:annotation>
    <xsd:sequence>
        <xsd:choice>
            <xsd:sequence>
                <xsd:element name="QueryType">
                    <xsd:annotation>
                        <xsd:documentation>Specifies the type of data source.</xsd:documentation>
                    </xsd:annotation>
                    <xsd:simpleType>
                        <xsd:restriction base="xsd:string">
                            <xsd:enumeration value="Access" />
                            <xsd:enumeration value="ADO" />
                            <xsd:enumeration value="DAO" />
                            <xsd:enumeration value="ODBC" />
                            <xsd:enumeration value="OLEDB" />
                            <xsd:enumeration value="Text" />
                            <xsd:enumeration value="Web" />
                        </xsd:restriction>
                    </xsd:simpleType>
                </xsd:element>
                <xsd:element name="CommandText" type="xsd:string" minOccurs="0" maxOccurs="unbounded">
                    <xsd:annotation>
                        <xsd:documentation>Contains the ODBC or OLE DB command string used to query data from a data source.</xsd:documentation>
                    </xsd:annotation>
                </xsd:element>
                <xsd:element name="CommandType" type="CommandType" default="None" minOccurs="0">
                    <xsd:annotation>
                        <xsd:documentation>Contains the type of command specified.</xsd:documentation>
                    </xsd:annotation>
                </xsd:element>
                <xsd:element name="Maintain" minOccurs="0">
                    <xsd:annotation>
                        <xsd:documentation>Specifies whether a connection is kept open.</xsd:documentation>
                    </xsd:annotation>
                </xsd:element>
                <xsd:element name="Connection" type="xsd:string" minOccurs="0" maxOccurs="unbounded">
                    <xsd:annotation>
                        <xsd:documentation>Contains the connection string of a data source, or the location of the data for a chart.</xsd:documentation>
                    </xsd:annotation>
                </xsd:element>
            </xsd:sequence>
            <xsd:sequence>
                <xsd:element name="Maintain" minOccurs="0">
                    <xsd:annotation>
                        <xsd:documentation>Specifies whether a connection is kept open.</xsd:documentation>
                    </xsd:annotation>
                </xsd:element>
                <xsd:element name="Connection" type="xsd:string" minOccurs="0" maxOccurs="unbounded">
                    <xsd:annotation>
                        <xsd:documentation>Contains the connection string of a data source, or the location of the data for a chart.</xsd:documentation>
                    </xsd:annotation>
                </xsd:element>
                <xsd:element name="CommandText" type="xsd:string" minOccurs="0" maxOccurs="unbounded">
                    <xsd:annotation>
                        <xsd:documentation>Contains the ODBC or OLE DB command string used to query data from a data source.</xsd:documentation>
                    </xsd:annotation>
                </xsd:element>
                <xsd:element name="CommandType" type="CommandType" default="None" minOccurs="0">
                    <xsd:annotation>
                        <xsd:documentation>Contains the type of command specified.</xsd:documentation>
                    </xsd:annotation>
                </xsd:element>
            </xsd:sequence>
        </xsd:choice>
        <xsd:element name="DoNotJoinDelimiters" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether consecutive delimiters are treated as one when importing data from a Web page.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="NoTextToColumns" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether text data is converted to columns when importing data from a Web page.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="DisableDateRecognition" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contain a Boolean value indicating whether Excel should force strings that look like dates to be imported as text.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="EnableRedirections" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>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.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="EditWebPage" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>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.</xsd:documentation>
            </xsd:annotation>
            <xsd:complexType>
                <xsd:attribute name="HRef" type="xsd:string" use="required">
                    <xsd:annotation>
                        <xsd:documentation>Specifies the URL of a Web page to be used as the data source when EnableRedirections is set to true.</xsd:documentation>
                    </xsd:annotation>
                </xsd:attribute>
            </xsd:complexType>
        </xsd:element>
        <xsd:element name="RefreshedInXl9" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a Boolean value to indicate whether the query table was last refreshed in Microsoft Excel 2000.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="EntirePage" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether the entire page is imported during a Web query.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="HTMLFormat" default="None" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the amount of formatting imported into a query table from a Web page.</xsd:documentation>
            </xsd:annotation>
            <xsd:simpleType>
                <xsd:restriction base="xsd:string">
                    <xsd:enumeration value="All" />
                    <xsd:enumeration value="None" />
                    <xsd:enumeration value="RTF" />
                </xsd:restriction>
            </xsd:simpleType>
        </xsd:element>
        <xsd:element name="URLString" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the URL of a Web page used as the data source.</xsd:documentation>
            </xsd:annotation>
            <xsd:complexType>
                <xsd:attribute name="HRef" type="xsd:string" use="required" form="qualified">
                    <xsd:annotation>
                        <xsd:documentation>Specifies the URL of a Web page used as the data source.</xsd:documentation>
                    </xsd:annotation>
                </xsd:attribute>
            </xsd:complexType>
        </xsd:element>
        <xsd:element name="WebPostString" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains the POST method parameters of a Web query.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="RefreshInfo" type="RefreshInfoType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains refresh information for the query.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="TextWizardSettings" type="TextWizardSettingsType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains the Text Import Wizard settings.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="HTMLTables" type="HTMLTablesType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the HTML tables on a Web page that are imported into a query table.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="UseSameSettings" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether the same text import options are used for an entire section on a Web page.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Query97" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether the query was created in Microsoft Excel 97.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="DoNotPromptForFile" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether to prompt the user for the name of a text file when performing a text file query.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="LocalConnection" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the text that defines the connection to the local cube slice on the client computer.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="SourceConnectionFile" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains the name of thefile where the data source connection settings came from when the query table or PivotTable view was created.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="SourceDataFile" type="xsd:string" minOccurs="0" maxOccurs="unbounded">
            <xsd:annotation>
                <xsd:documentation>Contains the name of source data file (such as an .mdb file) from which the data for the PivotTable view was originally retrieved.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="RobustConnect" type="OneZeroType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains values that specify how data connections are to be handled when data is refreshed.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="RefreshTimeSpan" type="xsd:int" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains an integer value specifying the number of minutes until the first data refresh and subsequent refreshes when automatic refreshes are enabled.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="VersionLastEdit" type="xsd:int" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Reserved for future use.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="VersionLastRefresh" type="xsd:int" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Reserved for future use.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="VersionRefreshableMin" type="xsd:int" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Reserved for future use.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Parameter" type="ParameterTypeE" minOccurs="0" maxOccurs="unbounded">
            <xsd:annotation>
                <xsd:documentation>Contains information about a query parameter.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
    </xsd:sequence>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
QueryType x:QueryType (1) (1)
CommandText x:CommandText 0 unbounded
CommandType x:CommandType 0 (1)
Maintain x:Maintain 0 (1)
Connection x:Connection 0 unbounded
Maintain x:Maintain 0 (1)
Connection x:Connection 0 unbounded
CommandText x:CommandText 0 unbounded
CommandType x:CommandType 0 (1)
DoNotJoinDelimiters x:DoNotJoinDelimiters 0 (1)
NoTextToColumns x:NoTextToColumns 0 (1)
DisableDateRecognition x:DisableDateRecognition 0 (1)
EnableRedirections x:EnableRedirections 0 (1)
EditWebPage x:EditWebPage 0 (1)
RefreshedInXl9 x:RefreshedInXl9 0 (1)
EntirePage x:EntirePage 0 (1)
HTMLFormat x:HTMLFormat 0 (1)
URLString x:URLString 0 (1)
WebPostString x:WebPostString 0 (1)
RefreshInfo x:RefreshInfo 0 (1)
TextWizardSettings x:TextWizardSettings 0 (1)
HTMLTables x:HTMLTables 0 (1)
UseSameSettings x:UseSameSettings 0 (1)
Query97 x:Query97 0 (1)
DoNotPromptForFile x:DoNotPromptForFile 0 (1)
LocalConnection x:LocalConnection 0 (1)
SourceConnectionFile x:SourceConnectionFile 0 (1)
SourceDataFile x:SourceDataFile 0 unbounded
RobustConnect x:RobustConnect 0 (1)
RefreshTimeSpan x:RefreshTimeSpan 0 (1)
VersionLastEdit x:VersionLastEdit 0 (1)
VersionLastRefresh x:VersionLastRefresh 0 (1)
VersionRefreshableMin x:VersionRefreshableMin 0 (1)
Parameter x:Parameter 0 unbounded
Collapse Derivation Tree:
Collapse References:
x:QuerySource, x:QuerySource
Documentation for Microsoft Office 2003 Reference Schemas

Generated using Liquid Studio - Developer Bundle 21.0.0.0