topic Re: ERROR 000006: Could not open the address table. in Data Management Questions https://community.esri.com/t5/data-management-questions/error-000006-could-not-open-the-address-table/m-p/208337#M11925 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">I created an address locator based on a shapefile of roads for a county. I created my table in excel (.xlsx). Checked and rechecked column headers and address formats. when I try to geocode the addresses it tells me "000006 : Could not open the address table." help?</BLOCKQUOTE><BR /><SPAN> </SPAN><BR /><SPAN>What version of ArcGis are you using. I don't think 9.3.1 and earlier will open xlsx files. If Im wrong about that, make super sure you have no spaces or special characters on you field names. Null values somewhere might toss you a curve as well.</SPAN></BODY></HTML> Tue, 12 Jul 2011 21:09:26 GMT JoeBorgione 2011-07-12T21:09:26Z ERROR 000006: Could not open the address table. https://community.esri.com/t5/data-management-questions/error-000006-could-not-open-the-address-table/m-p/208336#M11924 <HTML><HEAD></HEAD><BODY><SPAN>I created an address locator based on a shapefile of roads for a county. I created my table in excel (.xlsx). Checked and rechecked column headers and address formats. when I try to geocode the addresses it tells me "000006 : Could not open the address table." help?</SPAN></BODY></HTML> Tue, 12 Jul 2011 19:08:14 GMT https://community.esri.com/t5/data-management-questions/error-000006-could-not-open-the-address-table/m-p/208336#M11924 RyanShedd 2011-07-12T19:08:14Z Re: ERROR 000006: Could not open the address table. https://community.esri.com/t5/data-management-questions/error-000006-could-not-open-the-address-table/m-p/208337#M11925 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">I created an address locator based on a shapefile of roads for a county. I created my table in excel (.xlsx). Checked and rechecked column headers and address formats. when I try to geocode the addresses it tells me "000006 : Could not open the address table." help?</BLOCKQUOTE><BR /><SPAN> </SPAN><BR /><SPAN>What version of ArcGis are you using. I don't think 9.3.1 and earlier will open xlsx files. If Im wrong about that, make super sure you have no spaces or special characters on you field names. Null values somewhere might toss you a curve as well.</SPAN></BODY></HTML> Tue, 12 Jul 2011 21:09:26 GMT https://community.esri.com/t5/data-management-questions/error-000006-could-not-open-the-address-table/m-p/208337#M11925 JoeBorgione 2011-07-12T21:09:26Z Re: ERROR 000006: Could not open the address table. https://community.esri.com/t5/data-management-questions/error-000006-could-not-open-the-address-table/m-p/208338#M11926 <HTML><HEAD></HEAD><BODY><SPAN>Try using 97-2003 Excel format. I had the same problem</SPAN></BODY></HTML> Wed, 13 Jul 2011 14:44:59 GMT https://community.esri.com/t5/data-management-questions/error-000006-could-not-open-the-address-table/m-p/208338#M11926 JohnatanRojas 2011-07-13T14:44:59Z Re: ERROR 000006: Could not open the address table. https://community.esri.com/t5/data-management-questions/error-000006-could-not-open-the-address-table/m-p/208339#M11927 <HTML><HEAD></HEAD><BODY><SPAN>ArcGIS does not support xlsx format.&nbsp; You can save it as a xls if it isn't too big or convert it to a csv and it will work.</SPAN></BODY></HTML> Wed, 13 Jul 2011 15:41:25 GMT https://community.esri.com/t5/data-management-questions/error-000006-could-not-open-the-address-table/m-p/208339#M11927 BradNiemand 2011-07-13T15:41:25Z