ExcelToTable_conversion -- Table not in Geodatabase

JonathanMulder

Greetings,

I'm running the following code to convert an Excel spreadsheet to a dbf table inside a geodatabase.  But when I look at the geodatabase in ArcCatalog, the geodatabase does not contain the table.  Anty ideas?

CurrentDate = "20130625" OutName = "tempgdb.gdb" InSpreadsheet = "G:\Documents\GIS\HydstraData\HydstraMeasurementsDeep\HydstraMeasurements_" + CurrentDate + ".XLS" arcpy.ExcelToTable_conversion(InSpreadsheet,OutName)

Actually, my ultimate goal is to import points (Longitude, Latitude, Elevation) from a spreadsheet, but it seems I have to convert the spreadsheet to a table first, right?

Thanks for any help you can provide.

Jon Mulder

WilliamCraft

So what is your ultimate goal?  To generate and render points inside of ArcMap from your X,Y fields from the spreadsheet? 

In looking at the part of the code you provided, I think the reason no table ever gets created in your geodatabase is because the GP tool doesn't know where "tempgdb.gdb" is located on the file system.  Additionally, you need to specify the NAME of the output table.  Try something like this:

CurrentDate = "20130625"
OutName = "C:\folder_containing_your_source_GDB\tempgdb.gdb\OutputTable"
InSpreadsheet = "G:\Documents\GIS\HydstraData\HydstraMeasurementsDeep\HydstraMeasurements_" + CurrentDate + ".XLS"
arcpy.ExcelToTable_conversion(InSpreadsheet,OutName, "Sheet1")

Note that I've added an optional parameter to the GP tool above to reflect the Excel sheet name. 

Check your geodatabase after that and see if the table is there.  If so, that explains how to import the XLS into a file geodatabase. 

In terms of getting those points to appear on the map, from within ArcMap launch ArcToolbox and navigate to the Make XY Event Layer (Data Management) tool under Data Management.  Follow the directions from the help topic below to generate the points from your latitude and longitude fields once you point the tool to the new table in your file geodatabase from above. 

http://resources.arcgis.com/en/help/main/10.2/index.html#//00170000006z000000