AnsweredAssumed Answered

problem with Table to Table

Question asked by desertsp on Sep 21, 2016
Latest reply on Sep 21, 2016 by desertsp

I've encountered a problem with the Table to Table tool. While attempting to copy a table from a Personal Geodatabase (.mdb) into an INFO workspace (directory), field names are truncated to 10 characters. I'm executing the tool via the python code below.

convInfoWrkspace = "E:/info_workspace_directory/" #directory representing an INFO workspace
convTempPGDBTblOut = "pgdb_tbl" #table in the personal geodatabase. table is in the ArcMap TOC
convInfoNameOut = "info_tble" #table to be created in INFO workspace

arcpy.env.workspace = convInfoWrkspace
arcpy.env.overwriteOutput = True
arcpy.TableToTable_conversion(convTempPGDBTblOut,convInfoWrkspace,convInfoNameOut)

 

 

Interestingly, and I think tellingly, when using the same tool via the GUI (ArcToolbox), it won't even allow me to export to an INFO workspace. Instead, it adds a .dbf extension and creates a .dbf table. And, being a .dbf, the field names are truncated to 10 characters. The instructions for the tool state that by removing the .dbf extension on the output table name, an INFO table is created...but I'm unable to remove the ".dbf" - it's instantly re-added.

 

One more thing...I noticed that in Arc\INFO, the fields with truncated names actually do list the un-truncated name as the "alternate_name".

 

I realize INFO is going the way of the dodo, but does anyone have any suggestions on how to preserve the original field name?

 

This is occurring with version 10.1 SP1 (Build 3143).

Outcomes