import arcpy from arcpy import env ## Change this to your workspace location env.workspace = "C://WEXFORD//DATA" ## Change this to your spreadsheet and workbook name inTable = "C://WEXFORD//DATA//calculator.xlsx/sheet1$" outLocation = ""C://WEXFORD//DATA" outTable = "cal" arcpy.TableToTable_conversion(inTable,outLocation,outTable)
I'm not entirely sure about why you're getting that error, but can tell you that you can't use Excel tables with GP Services in 10.1.
You can use excel as a FILE (there are Python modules which read excel FILES...)
But ArcGIS Server cannot use Excel TABLES (the sheet you reference in your code with $).
You'll have to replace the excel table, or access it with other Python modules as a file.