>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
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]