Export .dbf to .csv

[Const]

Hi All,
I wanted to export a .dbf file to a .csv one. with COPY TO ... and some additive characters are added to my character fields.
Ex:
In the table, I have:
Field1 : Father
Field2 : Mother
In the .csv file the result is
Field1 : "Father"
Field2 : "Mother"
Extra (&quot characters have been added at the beginning and at the end.
Please help if someone has encountered the same problem
Thanks
Const

 

[Mike Gagnon]

Those are the delimiter character. You would need that, when you re-import the table, and need to specify the delimter character (so the import function knows where the field stops)

 

[DSummZZZ]

It's not a "problem", just a preference. Some people use quotes to delimit character fields. If all you are trying to do is delimit the fields with a comma, use:

COPY TO MyFile.CSV DELIMITED WITH ","

Dave S.