Text being converted to number (Append tool)

Discussion created by krosemanp on Jan 12, 2012
Latest reply on Jan 13, 2012 by jmward
I am attempting to add data to a SDE Table using the Append tool. The file is an excel file which contains a column with text such as 0001, 0151, BASE, etc. that is being converted to a number when importing. Anything with a value containing a letter (ie BASE) is being imported as null. The SDE Table column is text.

How can I get the data to append as stored in the excel file?