topic Re: How to write to .accdb? in Python Questions https://community.esri.com/t5/python-questions/how-to-write-to-accdb/m-p/582722#M45673 <HTML><HEAD></HEAD><BODY><SPAN>Hi Michael,</SPAN><BR /><SPAN>yes, I am on a 64-bit operating system. Windows 7 Enterprise.</SPAN><BR /><SPAN>The data is stored in a file geodatabase.</SPAN></BODY></HTML> Thu, 20 Jun 2013 14:54:28 GMT KatharinaPalffy-Gelfand 2013-06-20T14:54:28Z How to write to .accdb? https://community.esri.com/t5/python-questions/how-to-write-to-accdb/m-p/582720#M45671 <HTML><HEAD></HEAD><BODY><SPAN>Hi, </SPAN><BR /><SPAN>I have a script that writes data via an InsertCursor to a .mdb. Now that .mdb has been changed into an .accdb and my script does not work anymore. It is giving me an IO error that a specific table is not found. When I look in my .accdb, the table is there.</SPAN><BR /><SPAN>Do I need to connect to this new .accdb with the help of pyodbc? Does a regular insert cursor work then?</SPAN><BR /><SPAN>Your help would be appreciated.</SPAN></BODY></HTML> Thu, 20 Jun 2013 14:11:03 GMT https://community.esri.com/t5/python-questions/how-to-write-to-accdb/m-p/582720#M45671 KatharinaPalffy-Gelfand 2013-06-20T14:11:03Z Re: How to write to .accdb? https://community.esri.com/t5/python-questions/how-to-write-to-accdb/m-p/582721#M45672 <HTML><HEAD></HEAD><BODY><SPAN>Are you storing data in a personal geodatabase?&nbsp; Are you running on a machine with a 64 bit operating system?</SPAN></BODY></HTML> Thu, 20 Jun 2013 14:34:37 GMT https://community.esri.com/t5/python-questions/how-to-write-to-accdb/m-p/582721#M45672 MichaelVolz 2013-06-20T14:34:37Z Re: How to write to .accdb? https://community.esri.com/t5/python-questions/how-to-write-to-accdb/m-p/582722#M45673 <HTML><HEAD></HEAD><BODY><SPAN>Hi Michael,</SPAN><BR /><SPAN>yes, I am on a 64-bit operating system. Windows 7 Enterprise.</SPAN><BR /><SPAN>The data is stored in a file geodatabase.</SPAN></BODY></HTML> Thu, 20 Jun 2013 14:54:28 GMT https://community.esri.com/t5/python-questions/how-to-write-to-accdb/m-p/582722#M45673 KatharinaPalffy-Gelfand 2013-06-20T14:54:28Z Re: How to write to .accdb? https://community.esri.com/t5/python-questions/how-to-write-to-accdb/m-p/582723#M45674 <HTML><HEAD></HEAD><BODY><SPAN>In your initial post you wrote about an insert cursor to a .mdb which I believe is a personal geodatabase, but in your next post you said file geodatabase.&nbsp; Is it a personal or file geodatabase?</SPAN><BR /><BR /><SPAN>There was a thread about ESRI migrating away from personal geodatabases, so you may want to convert your .mdb to a file geodatabase (.gdb) and then run your script.</SPAN><BR /><BR /><SPAN>Look in the middle of this forum post for info from Mathew Coyle about personal geodatabases</SPAN><BR /><BR /><A href="http://forums.arcgis.com/threads/86999-Select-by-Attribute-and-Calculate-from-old-AML">http://forums.arcgis.com/threads/86999-Select-by-Attribute-and-Calculate-from-old-AML</A></BODY></HTML> Thu, 20 Jun 2013 16:36:47 GMT https://community.esri.com/t5/python-questions/how-to-write-to-accdb/m-p/582723#M45674 MichaelVolz 2013-06-20T16:36:47Z Re: How to write to .accdb? https://community.esri.com/t5/python-questions/how-to-write-to-accdb/m-p/582724#M45675 <HTML><HEAD></HEAD><BODY><SPAN>Hi Michael,</SPAN><BR /><SPAN>sorry to have confused you. Let me elaborate. I have a spatial database (file geodatabase) with my feature classes. Now I want to use arcpy.InsertCursor to write certain information from my feature classes like area and length to tables in an access database (.accdb). My question is: Do I need to connect to the .accdb first and can I then use arcpy.InsertCursor to write that information to it?</SPAN></BODY></HTML> Thu, 20 Jun 2013 16:49:43 GMT https://community.esri.com/t5/python-questions/how-to-write-to-accdb/m-p/582724#M45675 KatharinaPalffy-Gelfand 2013-06-20T16:49:43Z Re: How to write to .accdb? https://community.esri.com/t5/python-questions/how-to-write-to-accdb/m-p/582725#M45676 <HTML><HEAD></HEAD><BODY><SPAN>Katharina,</SPAN><BR /><BR /><SPAN>Try reading through this link. The short version is you </SPAN><SPAN style="font-style:italic;">should</SPAN><SPAN> connect to it first using pyodbc or some other method before you access it.</SPAN><BR /><A class="jive-link-external-small" href="http://support.esri.com/fr/knowledgebase/techarticles/detail/32976" rel="nofollow" target="_blank">http://support.esri.com/fr/knowledgebase/techarticles/detail/32976</A></BODY></HTML> Thu, 20 Jun 2013 16:56:46 GMT https://community.esri.com/t5/python-questions/how-to-write-to-accdb/m-p/582725#M45676 MathewCoyle 2013-06-20T16:56:46Z