>Morning
>
>Start of week and I have forgotten how to append data in CSV format into an existing table
>
>My Code
>
>
>USE j:\global\awbshayes IN 0 EXCLUSIVE
>SELECT awbshayes
>Append From j:\global\awbshayes.csv DELIMITED WITH '"' WITH CHAR '"
>
>Doesn't work
>
>Text is in double quotes , fields are comma delimited
>
>Quick help would be appreciated
Colin,

just out of the hip, see HELP APPEND FROM

Append From j:\global\awbshayes.csv DELIMITED

because "cfield",ifield
is the default for DELIMITED

Append From j:\global\awbshayes.csv DELIMITED WITH " WITH CHAR ,

or

Append From j:\global\awbshayes.csv DELIMITED WITH "" WITH CHAR ,

Lutz