topic Re: Copy table from MDB to MDB using Python in Python Questions https://community.esri.com/t5/python-questions/copy-table-from-mdb-to-mdb-using-python/m-p/405370#M31901 <HTML><HEAD></HEAD><BODY><P>Why not just use arcpy's copy <A href="http://desktop.arcgis.com/en/desktop/latest/tools/data-management-toolbox/copy.htm" title="http://desktop.arcgis.com/en/desktop/latest/tools/data-management-toolbox/copy.htm">Copy—Help | ArcGIS for Desktop</A>&nbsp; or <A href="http://desktop.arcgis.com/en/desktop/latest/tools/conversion-toolbox/table-to-table.htm" title="http://desktop.arcgis.com/en/desktop/latest/tools/conversion-toolbox/table-to-table.htm">Table To Table—Help | ArcGIS for Desktop</A> </P></BODY></HTML> Thu, 07 Jan 2016 17:57:43 GMT WesMiller 2016-01-07T17:57:43Z Copy table from MDB to MDB using Python https://community.esri.com/t5/python-questions/copy-table-from-mdb-to-mdb-using-python/m-p/405369#M31900 <HTML><HEAD></HEAD><BODY><P>I am trying to copy and table in a MS Access .mdb file to another .mdb file using Python. </P><P></P><P>I am able to connect to the source .mdb and read through the tables. This is done using the <A href="http://mkleehammer.github.io/pyodbc/" title="http://mkleehammer.github.io/pyodbc/">pyodbc</A> module. (SEE BELOW)</P><P></P><P>I'm just having trouble copying them.&nbsp; Should I use <A href="https://docs.python.org/2/library/shutil.html" title="https://docs.python.org/2/library/shutil.html">shutil</A> or os?</P><P></P><P>Any help is greatly appreciated!</P><P></P><P></P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/165816_pastedImage_2.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Thu, 07 Jan 2016 17:27:17 GMT https://community.esri.com/t5/python-questions/copy-table-from-mdb-to-mdb-using-python/m-p/405369#M31900 MitchHolley1 2016-01-07T17:27:17Z Re: Copy table from MDB to MDB using Python https://community.esri.com/t5/python-questions/copy-table-from-mdb-to-mdb-using-python/m-p/405370#M31901 <HTML><HEAD></HEAD><BODY><P>Why not just use arcpy's copy <A href="http://desktop.arcgis.com/en/desktop/latest/tools/data-management-toolbox/copy.htm" title="http://desktop.arcgis.com/en/desktop/latest/tools/data-management-toolbox/copy.htm">Copy—Help | ArcGIS for Desktop</A>&nbsp; or <A href="http://desktop.arcgis.com/en/desktop/latest/tools/conversion-toolbox/table-to-table.htm" title="http://desktop.arcgis.com/en/desktop/latest/tools/conversion-toolbox/table-to-table.htm">Table To Table—Help | ArcGIS for Desktop</A> </P></BODY></HTML> Thu, 07 Jan 2016 17:57:43 GMT https://community.esri.com/t5/python-questions/copy-table-from-mdb-to-mdb-using-python/m-p/405370#M31901 WesMiller 2016-01-07T17:57:43Z Re: Copy table from MDB to MDB using Python https://community.esri.com/t5/python-questions/copy-table-from-mdb-to-mdb-using-python/m-p/405371#M31902 <HTML><HEAD></HEAD><BODY><P>Cause I'm still learning... haha! </P><P></P><P>Thank you Wes!</P></BODY></HTML> Thu, 07 Jan 2016 18:05:45 GMT https://community.esri.com/t5/python-questions/copy-table-from-mdb-to-mdb-using-python/m-p/405371#M31902 MitchHolley1 2016-01-07T18:05:45Z Re: Copy table from MDB to MDB using Python https://community.esri.com/t5/python-questions/copy-table-from-mdb-to-mdb-using-python/m-p/405372#M31903 <HTML><HEAD></HEAD><BODY><P>You and me both are still learning</P></BODY></HTML> Thu, 07 Jan 2016 18:14:04 GMT https://community.esri.com/t5/python-questions/copy-table-from-mdb-to-mdb-using-python/m-p/405372#M31903 WesMiller 2016-01-07T18:14:04Z