How can I import french characters (accents)

[FixTr]

I'm doing a bulk insert using a DTS package. The data source is an export text file from MS Access. The data contains french characters (with accents, è,à...).
Once the data is imported, all the accents are gone, replaced by upper case letters such as T, F, G.

How can I import those characters with the accent in the database. SQL 7 has been installed with LCID 1036 (french).

Please help,

Thanks !

 

[PROPAR]

It may help to try opening the file and saving it in a different file format.
It worked well for me when I tried to import a notepad or workpad produced file with SQLServer 6.5 BCP ( use an editor like UltraEdit and save the file from ANSI file format to OEM file format, or from OEM to ANSI...).
However, the command-line options of SQLServer 7 are much richer than 6.5 vintage, and the aim may be achieved with
"bcp ... -C ACP ..." or "bcp ... -C OEM ...."

 

[FixTr]

Oh Man, converting the file from ANSI to OEM in UltraEdit worked !!!
Thanks a bunch Propar, I'm quite new to SQL server so I'm not fully aware of all those little tricks.

Thanks again for the great help !

FixTr