I am trying to do a bulk insert form csv file. The file may contain some french characters. When I open the file in notepad, the french character shows up fine, when Iopen the same file in excel, the french charatcer turns into something like MÃ‰NAR001 as opposed to MÉNAR001 shown in note pad.
When I bulk insert this file using following SQL statement:
bulk insert dbo.TestBulk from 'D:\ReportTest.csv'
CODEPAGE = 'ACP',
FIELDTERMINATOR = '|',
ROWTERMINATOR = '\n'
the field does not contain french charatcers.
I tried using codepage values like RAW,OEM,65001, but the field still contains strange characters.
Thanks in advance,