I have a very big dataset in a gbd. I would like to export it to an excel file. I use the following code:
startingP = r"C:\Directory\ArcGIS\By_Coding.gdb\MyInput" endingP = r"C:\Directory\ArcGIS\By_Coding.gdb\Output.xls" arcpy.TableToExcel_conversion (startingP,endingP)
But what I get is:
ExecuteError: Failed to execute. Parameters are not valid. ERROR 000814: Invalid file type
I have already seen in another question that it was suggested to combine
arcpy.TabletoExcel_conversion with other tools like
MakeTableView_managementbut it sounds weird to me that there is no faster way to do it, because I always thought the arcpy functions perfectly replicated the corresponding Arcgis toolbox tools, and if I use
Arctoolbox > Conversion Tools > Excel > Excel to Table using the input file "MyInput" as "Input Table", it works. Is therefore any mistake in the way I call my variables in the code?