Russell Fields
3/29/2007 2:41:00 PM
Marc,
Can you use CharacterSet=RAW in your format file?
With bcp RAW is the option that avoids any data conversion during the copy.
RLF
"Marc Robitaille" <marc.marie AT globetrotter.net.del> wrote in message
news:OGMA0lgcHHA.2088@TK2MSFTNGP05.phx.gbl...
> Hello,
>
> I need help with this.
>
> This is an exemple of datas that I have to import.
>
> ENL80051403;015678A5;O;"Société Sylvicole Chambord ltée";O;"Société
> Sylvicole Chambord ltée";R;1143285790;O;2010-01-01
>
>
> This is what I use to import de datas in the table
>
> insert TDE001
> select * from OpenRowset('MSDASQL', 'Driver={Microsoft Text Driver (*.txt;
> *.csv)};DefaultDir=C:\Dev\ASSPPQ\Importation\Transfert\20070131\','select
> * from TDE001.csv')
>
> This is the schema.ini file
>
> [TDE001.csv]
> ColNameHeader=False
> Format=Delimited(;)
> MaxScanRows=0
> CharacterSet=ANSI
> COL1=no_empl char width 12
> COL2=no_dexp char width 12
> COL3=codet_doss_empl char width 1
> COL4=nom_doss_csst text width 152
> COL5=codet_dexp char width 1
> COL6=nom_usu_desig_dexp char width 152
> COL7=codt_dexp char width 1
> COL8=no_neq char width 10
> COL9=ind_autor_dexp char width 1
> COL10=dat_fin_acces char width 10
>
> This is the result
>
> ENL80051403 015678A5 O SociÚtÚ Sylvicole Chambord ltÚe O SociÚtÚ Sylvicole
> Chambord ltÚe R 1143285790 O 2010-01-01
>
> As you can see I have this problem
>
> Before
> Société
>
> After
> SociÚtÚ
>
> I try this
> CharacterSet=OEM
>
> I ended with this
> ENL80051403 015678A5 O Soci?t? Sylvicole Chambord lt?e O Soci?t? Sylvicole
> Chambord lt?e R 1143285790 O 2010-01-01
>
> What can I do to keep my accentuated characters?
>
> Thank you
>
> Marc R.
>
>
>
>
>