I'd like to import data from a dBase file to SQL2000 via DTS on a
repeating basis. I can create a scheduled DTS task and it
generally works OK but some international characters don't
convert accurately. For example, city names like Koln, Sao Paulo and
Quebec are likely to lose the vowel marks.
I can get the data via an Excel query and it works fine.
If I save the Excel file and import it from Excel to SQL2000 via DTS
it also seems to convert accurately, but I'd rather not have the Excel
intermediate
file/task.
Any suggestions?