topic Re: joining an excel spreadsheet in Data Management Questions https://community.esri.com/t5/data-management-questions/joining-an-excel-spreadsheet/m-p/723612#M40990 <HTML><HEAD></HEAD><BODY><SPAN>Because it is looking for the excel table on your computer.</SPAN><BR /><BR /><SPAN>i.e say you put it in c:\exceltables\&nbsp; and you put the mxd on your network and your network is the s:\ drive it does not have c:\exceltables\</SPAN><BR /><BR /><SPAN>You need to put the spreadsheet on the network and re-path your mxd to point to that directory.</SPAN><BR /><BR /><BR /><BR /><BLOCKQUOTE class="jive-quote">I am using an excel spreadsheet, joining it to some data in my map. I have been able to join if i put the spreadsheet on my computer, but if I try to access it over the network, it will not connect. I get "failed to connect to database. General function failure. External table is not in the expected format. Can someone tell me why it will connect from my computer but not thru the nextwork?&nbsp; Is there a limit to the number of characters in the path?</BLOCKQUOTE></BODY></HTML> Fri, 20 Dec 2013 15:29:28 GMT RobertBorchert 2013-12-20T15:29:28Z joining an excel spreadsheet https://community.esri.com/t5/data-management-questions/joining-an-excel-spreadsheet/m-p/723611#M40989 <HTML><HEAD></HEAD><BODY><SPAN>I am using an excel spreadsheet, joining it to some data in my map. I have been able to join if i put the spreadsheet on my computer, but if I try to access it over the network, it will not connect. I get "failed to connect to database. General function failure. External table is not in the expected format. Can someone tell me why it will connect from my computer but not thru the nextwork?&nbsp; Is there a limit to the number of characters in the path?</SPAN></BODY></HTML> Mon, 16 Dec 2013 20:06:48 GMT https://community.esri.com/t5/data-management-questions/joining-an-excel-spreadsheet/m-p/723611#M40989 MikeHenson 2013-12-16T20:06:48Z Re: joining an excel spreadsheet https://community.esri.com/t5/data-management-questions/joining-an-excel-spreadsheet/m-p/723612#M40990 <HTML><HEAD></HEAD><BODY><SPAN>Because it is looking for the excel table on your computer.</SPAN><BR /><BR /><SPAN>i.e say you put it in c:\exceltables\&nbsp; and you put the mxd on your network and your network is the s:\ drive it does not have c:\exceltables\</SPAN><BR /><BR /><SPAN>You need to put the spreadsheet on the network and re-path your mxd to point to that directory.</SPAN><BR /><BR /><BR /><BR /><BLOCKQUOTE class="jive-quote">I am using an excel spreadsheet, joining it to some data in my map. I have been able to join if i put the spreadsheet on my computer, but if I try to access it over the network, it will not connect. I get "failed to connect to database. General function failure. External table is not in the expected format. Can someone tell me why it will connect from my computer but not thru the nextwork?&nbsp; Is there a limit to the number of characters in the path?</BLOCKQUOTE></BODY></HTML> Fri, 20 Dec 2013 15:29:28 GMT https://community.esri.com/t5/data-management-questions/joining-an-excel-spreadsheet/m-p/723612#M40990 RobertBorchert 2013-12-20T15:29:28Z