Hi Lutz

OK now VFP wasnt compiling programs properly

Thanks for your help

Colin




>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