That is it for sure. I could import the field into Excel and into Access but not into SQL Server. Turns out the first 8 rows were null so JET didn't see the field as a text field.

Thanks