Exporting Foreign Characters to Text File

[bradsta]

Hi,

I'm exporting a list of names to a comma delimited text files. Some of the names use foriegn charaters (eg. Lütjens) that don't export correctly to the file.

I have tried changing the File type to ANSI, OEM and Unicode in the text file properties but none of them export the characters in the way they appear in the SQL table.

Any ideas?

Thanks,
Brad