jplay

TableToTable and Excel 000732 Error

Discussion created by jplay on Feb 14, 2014
Latest reply on Feb 18, 2014 by Caleb1987
Having a weird problem running a TableToTable conversion using a python script. The script has worked without issue for months. This morning I continue to get a 000732 : <value>: Dataset <value> does not exist or is not supported error. I have tried recreating the excel spread sheet, moving it to a different location, rewriting the script, exporting the code from model builder, etc. If I try to run the process from ToolBox I get the same error.

The weird thing is if I run the same process on the same xlsx in model builder, I have no problem.



Suggestions?

OUTFILE = arcpy.GetParameterAsText(0)
NCFMPFolder = arcpy.GetParameterAsText(1)
DATE = str(datetime.date.today())
Sheet1 = os.path.join(NCFMPFolder,"DeliveryTracking.xlsx\Sheet1$")
DeliveryTrackinggdb = os.path.join(NCFMPFolder,"DeliveryTracking.gdb")

# Process: Table to Table
arcpy.TableToTable_conversion(Sheet1, DeliveryTrackinggdb, "Tracking", "", "DO \"DO\" true true false 8 Double 6 15 ,First,#,Sheet1,DO,-1,-1;TASK \"TASK\" true true false 255 Text 0 0 ,First,#,Sheet1,TASK,-1,-1;SUB_TASK \"SUB_TASK\" true true false 255 Text 0 0 ,First,#,Sheet1,SUB_TASK,-1,-1;CONT \"CONT\" true true false 255 Text 0 0 ,First,#,Sheet1,CONT,-1,-1;COUNTY \"COUNTY\" true true false 255 Text 0 0 ,First,#,Sheet1,COUNTY,-1,-1;APPRVD \"APPRVD\" true true false 8 Date 0 0 ,First,#,Sheet1,APPRVD,-1,-1;STATUS \"STATUS\" true true false 255 Text 0 0 ,First,#,Sheet1,STATUS,-1,-1", "")

Outcomes