Sorry. In this case, I simply put a single quote "'" in front each entry with a two digit number, so they were all interpreted as text. The list was short enough for this to be a good and timely answer.
Please note that Sergey put in a link to a more complete answer to this problem.
>If you mark your own message as the solution to the thread, please post the solution in the marked message so others may benefit. Typically, if any stars display with a message then the users expect to see a resolution as well.
>
>
>>I am trying to import a table from Excel that has a column that is two chars in lenth. Some of the entries are made up of two numbers, some of a number and a char, and some of two chars. I have formatted the Excel cells as text, and I have made sure that the first entry row is a two char entry, but DTS still is interpreting the column as a INT and does not see the entries that are not just two numbers. How can I get past this?
>>
>>-- Later - There has not yet been a reply to this message, and I have found a solution.
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.