Connection XML

<connection id="6" odcFile="c:\…\xlextdat8 Northwind Summary of Sales by
  Year.odc" keepAlive="1"
  name="xlextdat8 Northwind Summary of Sales by Year" 
  type="5" refreshedVersion="3" background="1" saveData="1">
  <dbPr connection="Provider=SQLOLEDB.1;Integrated Security=SSPI;
    Persist Security Info=True;Initial Catalog=Northwind;Data
    Source=xlextdat8;Use Procedure for Prepare=1;Auto 
    Translate=True;Packet Size=4096;Workstation ID=CHADROTHO12;Use
    Encryption for Data=False;Tag with column collation when 
    possible=False" command="&quot;Northwind&quot;.&quot;dbo&quot;
   .&quot;Summary of Sales by Year&quot;" commandType="3"/>
</connection>

• @type value of 5 indicates that this connection is using an OLEDB data provider.

• @commandType value of 3 specifies that a table name is in command

• @command specifies a table name.