AnsweredAssumed Answered

Converting Excel files to GDB question

Question asked by mimiller on May 1, 2012
Latest reply on May 1, 2012 by mimiller
What is the proper method of accessing excel files using Python?

I'm using the below code and it returns the following error message:
ERROR 000732: Input Rows: Dataset 2005.xlsx does not exist or is not supported
Failed to execute (TableToTable).

import arcpy import os arcpy.env.overwriteOutput = 1 arcpy.env.workspace = r"\\itdhq1apt50\GIS_Data\Test_MM\KellyRawCrash" for file in arcpy.ListFiles("*.xlsx"):     outBase, outExt = os.path.splitext(file)     outCrash = "Crash" + outBase     print file     print outCrash     arcpy.TableToTable_conversion(file, gdb_loc, outCrash)


Michael Miller

Outcomes