yes i do..

If I follow the steps below I can translate to chinese characters:

>Open excel

>Open the text file and when it prompts for encoding type to be applied for the columns, on choosing 'Chinese simplified', the supplier name changes to chinese word

I can't do this for every file I receive bcoz the files are sent from Oracle and no.of files that are received are not fixed. My loader script runs twice a day to load these data. So the solution am expecting is, something to do in the script or to do in the SQL server.

Thanks