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
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing