When I input the table in the dialog box, I get this rather long error:
ERROR updateParameters Execution Error: Runtime error Traceback (most recent call last):
File "c:\program files (x86)\arcgis\desktop10.3\ArcToolbox\Toolboxes\Conversion Tools.tbx#ExcelToTable_conversion.UpdateParameters.py",
line 4, in
File "c:\program files (x86)\arcgis\desktop10.3\ArcToolbox\Toolboxes\Conversion Tools.tbx#ExcelToTable_conversion.UpdateParameters.py",
line 40, in updateParameters
File "C:\Program Files (x86)\ArcGIS\Desktop10.3\ArcToolBox\Scripts\ExcelToTable.py",
line 125, in get_sheet_names workbook = xlrd.open_workbook(in_excel)
File "C:\Python27\ArcGIS10.3\lib\site-packages\xlrd\__init__.py",
line 416, in open_workbook ragged_rows=ragged_rows,
File "C:\Python27\ArcGIS10.3\lib\site-packages\xlrd\xlsx.py",
line 705, in open_workbook_2007_xml ensure_elementtree_imported(verbosity, logfile)
File "C:\Python27\ArcGIS10.3\lib\site-packages\xlrd\xlsx.py",
line 46, in ensure_elementtree_imported ET.iterparse(_dummy_stream)
File "C:\Python27\ArcGIS10.3\Lib\xml\etree\ElementTree.py",
line 1194, in iterparse parser = XMLParser(target=TreeBuilder())
File "C:\Python27\ArcGIS10.3\Lib\xml\etree\ElementTree.py",
line 1446, in __init__
"No module named expat; use SimpleXMLTreeBuilder instead" ImportError: No module named expat; use SimpleXMLTreeBuilder instead
Doing some research, I found here that I might need to upgrade the python. I am new to Python, and I installed 2.7.8 and the tool worked previously. I use Windows 8.1 and it's a 64-bit system. I tried installing the newer python and I got "missing VCRUNTIME140.dll" and I have not found where to fix that yet.