Connection XML

<connection id="4" name="Query from MS Access Database" type="1"
  refreshedVersion="3" background="1" saveData="1">
  <dbPr connection="DSN=MS Access
     Database;DBQ=E:\…\Database1.accdb;DefaultDir=E:\Documents and 
     Settings\chadroth\Desktop;DriverId=25;FIL=MS 
     Access;MaxBufferSize=2048;PageTimeout=5;"
       command="SELECT Table1.ID, 
       Table1.Field1, Table1.Field2,
       Table1.Field3_x000d__x000a_FROM 
      `E:\…\Database1.accdb`.Table1 Table1"/>
</connection>

• @type value of 1 indicates ODBC connection type.

• @command contents are an SQL select statement.