>>>>FWIW never append from a CSV as CSV.
>>>>Cetin
>>>
>>>Yeah? Why? I need to import census data, to populate part of my database, that's supplied in CSV for. Now you've got me worried :-(
>>>
>>>Terry
>>
>>Terry,
>>Here is a simple example:
>>
>>Text to m.lcSample noshow
>>Name,BirthDate
>>n1,10/10/69
>>n2,01/01/1981
>>EndText
>>lcFile = Sys(2015)+".csv"
>>StrToFile(m.lcSample,m.lcFile)
>>
>>create cursor test (name c(10),birthdate d)
>>append from (m.lcFile) type csv
>>Erase (m.lcFile)
>>browse
>>
>>Try also using delimited instead of csv. You'd see why.
>>Cetin
>
>Hi cetin
>
>Hmmm ... interesting. Is it only the dates that are dodgy or are there problems with other data types? Just realised that there must have been some problem with importing from CSV files, some time ago, when I wrote it, cos I've just remembered that I insisted on XLS for import file :-) However, my import data, although Census info, bore no dates. Maybe I wrote it back in VFP 5 days and there was a problem with that - I don't know.
>
>Terry
Terry,
I don't know. Seeing that with a datatype was sufficient for me not to test with all types and use delimited instead.
Cetin