<br><b>Code</b>: rsb:print<br><b>Error</b>: Formatter [ extraconnectionprops ] failed in the evaluation of <p> CData ODBC driver for [service] ????ODBC ????????????[datasource] ?Microsoft Access ?Excel ???????????????????????????Microsoft Query ????[datasource] ??????????????????????????????????????????????????? </p> <ol> <li>?????????????????DSN(???????)?????????Microsoft ODBC ????????????????????ODBC DSN ?????????????</p> <p> ?????????????????: </p> <p> [extraconnectionprops] </p> <p>Microsoft ODBC ????????????????????????????????????????????????????????????</p> </li> <li>Excel ?[Data]?????[From Other Sources]>[From Microsoft Query]??????</li> <img src='../articles/odbc-excel-query-1.png' title="Open Microsoft Query from the Data tab."/> <li>???????????????Microsoft Office ????????????32 bit CData [service] Source ???64 bit CData [service] Source x64 DSN ??????Query Wizard ???????????????????/??????</li> <img src='../articles/odbc-excel-query-2.png' title="The list of available ODBC DSNs in the Choose Data Source dialog."/> <li>Query Wizard ?????????????????????????????????????????????????????????????????????????????????????????????????????????</li> <img src='../articles/odbc-excel-query-3.png' title="Available tables and columns in the Choose Columns step of the Query Wizard. (Salesforce is shown.)"/> <li>[Filter Data]?????????????????????????????????????????</li> <img src='../articles/odbc-excel-query-4.png' title="The Filter Data step of the Query Wizard. (Salesforce is shown.)"/> <li>??????????????????Microsoft Query ?????????????????????</p> </li> <li><p>?????????????????SQL ????????????????????????????[Query Editor]?[SQL]?????????????????????????????????????????WHERE ????????</p><p>???????????WHERE ????????????????????? "?" ?????????[extable] ??????????????"[exselectwherecol]=?" ????????</p> <li>SQL ????????????????[SQL]?????????????????????????????????????????????????????????????????????????????????????</p> </li> <img src='../articles/odbc-excel-query-7.png' title="The generated SQL statement. (Salesforce is shown.)"/> <li> <p>Microsoft Query ??????[Import Data]???????????????????????????????? <img src='../articles/odbc-excel-query-8.png' title="The Import Data dialog."/> </li> <li>[Import Data]????????????????????????????????????????????????????????????????????????????????????????????????????????? </ol> ???????Excel ??????????????B1?????????????????????????????????????? <img src='../articles/odbc-excel-query-9.png' title="The results of the query, with the search criteria applied. (Salesforce is shown.)"/>. The error was: The value of the attribute could not be accessed: The attribute does not exist.<br><b>URL</b>: /jp/kb/tech/alfresco-odbc-excel-query.rst