I downloaded and added the 'Export to Excel' model tool to a custom modelbuilder script. Great tool! Thank you!! I am not certain when or where I made the error, however; the XLS 'Date' column came across formatted as 'double', with unintelligible results (see attached). Any suggestions as to how I can have the original dates convert without alteration?
dates are actually stored in computers as days since 1900 (or sometimes 1901, I think), this is the number you are seeing. To show them as dates again you need to tell the program opening them that they are dates. So, if you open the output file in Excel, select the column and set format to date it should show in excel, and possibly when you open it in Arc again also. If that doesn't work, and you actually want to use the Excel file within Arc, you will probably need to make a new field of type date, and set it to the old field value, and it ought to convert.
Can anyone help me get this working in Arcmap? I know just enough programming to be dangerous but do not have a lot of experience with Python. I load the tool but it says there are no parameters, I assume when I load it I need to identify what the variables are? I tried running it directly in the python window and replaced all the "dataset" inputs with my dataset name. It still didn't work so I assume there is more I need to edit. I would prefer to be able to load it into a toolbox tool rather than running script in the python window.
You shouldn't have to program anything. Extract the contents of the zip file to a location. Navigate the ArcCatalog window (in ArcMap) to that location, expand the toolbox - called "Additional Conversion - Generic Tools" - then double click on the "Table to Excel" function in there. The parameters are already set up.