I have a problem. I am trying to import an excel spreasheet that has a Zip Code column that is sporatically formatted as either a number or as a text. When I try to import it into a table via a DTS package It converts the numbers formatted as strings into empty strings or nulls depending on how I do the translations. I have tried eveything I could think of to resolve this problem, even highlighted the while sheet as set to text datatype but when the DTS package reads in the excel file it still interupts the Zip Code field as a float and turns the sporatically formmated Numbers as text to NULL. Any suggestions on how I can force the import of all data values in thif field regardless of its formatting in my excel file?