Hi Lutz

I have recreated my dbf and have manually imported the data into it

I am now trying to import again by program

use j:\global\awbshayes in 0 shared
select awbshayes
Append From j:\global\awbshayes.csv DELIMITED WITH "" WITH CHAR ,

Nothing gets added and there are no errors

What am I doing wrong

Colin




>>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