Arcpy Table to Table Conversion of multiple tables

ColeNelson

Hello everyone, I'm working on creating a tool that will allow me to select multiple tables from an Access Database and convert them to standalone tables in a Geodatabase:

I created a .odc database connection to the Access database the tables are being stored in hopes to make it easier to select the tables.  Here is the script that I have so far:

import arcpy
import os

#Allow code to overwrite existing datasets
arcpy.env.overwriteOutput = True

#Set the variables
workspace =  r"C:\UpdateDevelopmentPython\ForDeveloping\isrb_business.odc"
tables = arcpy.GetParameterAsText(0).split(";")
outpath = r"C:\UpdateDevelopmentPython\ForDeveloping\ForDeveloping.gdb"
outfile = os.path.join(workspace, "{}" .format(os.path.join(workspace) + str(["baseName"])))

#Create the standalone tables
TblResponseID = arcpy.TableToTable_conversion(tables,outpath,outfile)

 However whenever I run the the tool I keep getting this message.

import arcpy

import os

#Allow code to overwrite existing datasets

arcpy.env.overwriteOutput = True

#Set the variables

workspace =  r"C:\UpdateDevelopmentPython\ForDeveloping\isrb_business.odc"

tables = arcpy.GetParameterAsText(0).split(";")

outpath = r"C:\UpdateDevelopmentPython\ForDeveloping\ForDeveloping.gdb"

outfile = os.path.join(workspace, "{}" .format(os.path.join(workspace) + str(["baseName"])))

#Create the standalone tables

TblResponseID = arcpy.TableToTable_conversion(tables,outpath,outfile)

 

I want the new standalone tables to keep the same name as the original Access tables, is there a way to do this?  Thanks for the help!

 

Anonymous User

The parameters for the TableToTable are not right. It is expecting an input table, the output path, and just the output table name.  You have a full path (and string of a list "baseName") going into the table name parameter. 

Set your code up in a loop to iterate over the list of tables you get and you can grab the name of each table for the output.  Like Don mentioned, add some print statements or set some breakpoints and debug so you can see what your variables look like.

tables = arcpy.GetParameterAsText(0).split(';')

outpath = r"C:\UpdateDevelopmentPython\ForDeveloping\ForDeveloping.gdb"

for tble in tables:
    baseName = os.path.basename(table)
    #Create the standalone tables
    TblResponseID = arcpy.TableToTable_conversion(tble, outpath, baseName)