How can i bulk insert dashes?

when i do a bulk insert with dashes (i.e. one - two), i get the character u with two dots above it ( ü ) in place of all the dashes? can't seem to figure out why. the field terminator is a comma ( , ).

i'm inserting just text with dashes into char(75) field.

can someone explain and provide a solution? i would greatly appreciate it!

my script is quite simple, maybe i'm missing something.

Code Snippet

bulk insert testtable

from '\\local\c$\adjust.txt'

with (fieldterminator = ',')

thanks!

nevermind, i figured it out... it seems the dashes were not actually dashes, but the symbol that word autocorrects when you type in a dash. seems the strings were copied from a word document and formatted that way.

it works fine now, just replaced all the dash symbols with actual dashes.