AnsweredAssumed Answered

Specify a field type with Excel to Table

Question asked by jborgion Champion on Sep 4, 2019
Latest reply on Sep 5, 2019 by Dan_Patterson

I have a python script that uses the ExcelToTable_management() method. One of the fields in excel worksheet is zipcode, and in the past, at least one of the values is in the form of zip + 4 (84124-1234) so the new table zipcode field gets cast as text.

 

However, I just got a new excel file for the month of August, and none of the data in the original zipcode field is zip + 4, so ExcelToTable_management() converts them to a long int.  That's okay but my entire script is dependent on the field being text.  When I look at the spreadsheet itself, the zipcode column is in 'General' format.

 

I kind of doubt there is a way to convince ExcelToTable_management() that when it reads that zipcode column to treat it as text regardless of what it reads, but I thought I'd ask none-the-less....

Outcomes