Problem with import table

[_ukaszZaremba]

Hello,

I have a source geodatabase with three tables: Table_A, Table_B and Table_C.
I would like to export two of them to another geodatabase.
The list of tables I would like to export is written in txt files.

I've written a script in Python to do that but I have an error when I run it.


When the list contains only one table's name, the export is accomplished correctly.

Can You help mi with this script?

import arcpy

source="C:\\Data\\Data.gdb\\"
destination="C:\\Data\\Base.gdb"
Tables="C:\\Data\\Tables.txt"

w=open(Tables,'r')
lines=w.readlines()
for line in lines:
arcpy.TableToTable_conversion(source+line,destination,line)
w.close()

Error:
"arcgisscripting.ExecuteError: ERROR 999999: Error executing function.
The table was not found.
The table was not found. [Table_A]
Failed to execute (TableToTable)."

[GuidoStein]

table to table is not a line by line cursor for writing tables, you should be able to point directly to your tables and set the output destination and name.

[KevinBell]

...just a guess, but is it the // on the end of your source string?

[Anonymous User]

I have a source geodatabase with three tables: Table_A, Table_B and Table_C.
I would like to export two of them to another geodatabase.
The list of tables I would like to export is written in txt files.

It would be much easier to use the ListTables() function. 

import arcpy, os
from os import path as p

arcpy.env.workspace = source = r"C:\Data\Data.gdb"
destination= r"C:\Data\Base.gdb"

for table in arcpy.ListTables('Table_*'):    # IF tables really are named  like Table_A
    arcpy.TableToTable_conversion(p.join(source,table),destination,table)
    print 'Exported %s to %s'  %(table,destination)

[_ukaszZaremba]

Yes, there is. For one table in txt file it works.

The same script with import feature classes from one geodatabase to another (FeatureClassToGeodatabase_conversion), works correct.

[_ukaszZaremba]

It would be much easier to use the ListTables() function. 

import arcpy, os
from os import path as p

arcpy.env.workspace = source = r"C:\Data\Data.gdb"
destination= r"C:\Data\Base.gdb"

for table in arcpy.ListTables('Table_*'):    # IF tables really are named  like Table_A
    arcpy.TableToTable_conversion(p.join(source,table),destination,table)
    print 'Exported %s to %s'  %(table,destination)

OK, but I would like to import not all tables from source geodatabase (only Table_A and Table_B). I'm not interested in Table_C .

Thanks for help.

[Anonymous User]

OK, but I would like to import not all tables from source geodatabase (only Table_A and Table_B). I'm not interested in Table_C .

This can be done easily with an if test.  For example, "if table != 'Table_C:'"

This will exclude Table_C

import arcpy, os
from os import path as p

arcpy.env.workspace = source = r"C:\Data\Data.gdb"
destination= r"C:\Data\Base.gdb"

for table in arcpy.ListTables():  
    if table != 'Table_C': 
        arcpy.TableToTable_conversion(p.join(source,table),destination,table)
        print 'Exported %s to %s'  %(table,destination)

[T__WayneWhitley]

for table in ['Table_A', 'Table_B']:

Replace that line in Caleb's code, will that work --- substituting one list for a more limited list.  Give Caleb credit, if you will.

EDIT:  Hello Caleb - you get at least a point on that 1st bit about ListTables, all in the same line with the string filter.  Just for the 'clean-appeal'.

[Anonymous User]

for table in ['Table_A', 'Table_B']:

Even better 🙂

[_ukaszZaremba]

Thank you for help.

I'm curious why my solution does not work? 🙂
Is it possible to use txt file?