I have large excel tables with geochemical information that I am importing to ArcGIS. TableToTable works, but there are likely restrictions to the number of columns that can be imported directly from excel as the last columns of my sheet are not included in the table when I open it in ArcGIS. Converting the excel table to csv and importing fixes this, but....
My question is related to the resulting field names and aliases. The headers in my excel/csv table contain special characters that are converted to underscore on import, but I would like to keep these headers as aliases for each field. It is possible to set the resulting aliases manually using the Field Map in the TableToTable conversion tool, but since I have hundreds of columns, I would like to automate this process in a python script.
Can I add the Field Map function to my script such that the headers in the csv table are maintained as Aliases in the new table?
inTable = "Data.csv"
outDB = "Data.gdb"
outTable = "Data"
arcpy.TableToTable_conversion(inTable, outDB, outTable)