What about memo fields in DTS ?


>>I looked at DTS. I need total control or as much as I can have, there are
>> quite a few data issues (different issues per table, not all tables. Key
>> fields being right aligned or padded ' ' left) overall so I went the SPT
>> route.
>>
>
>
>if you haven't already spent a ton of time doing it another way,
>i agree with Cetin's suggestion to use DTS. not super fast, but
>quite powerful. you can do (data-type) conversions and substitutions
>during the import procedure using DTS. took me a while to learn
>all the intracies, but a great tool.