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