I have an Access database I want to pump into SQL using DTS... However, the
address field is one big field, with lines seperated by Chr(13) and Chr(10).
I want these to be split and put into AddresLine1, AddressLine2 and
AddressLine3 fields in the SQL database.
Is this possible?