>Does the APPEND FROM (a CSV file) command respect SET CENTURY ... ROLLOVER settings?
>
>I am importing data from an Excel CSV file that has dates specified as 8 characters or 10 characters (I have no control over the source of this data). Obviously, the 8 char dates are assumed to be from the 20th century but irrespective of my SET CENTURY ... ROLLOVER settings, the dates are not being converted properly from the CSV into the DBF.
>
>I seem to recall that there are problems with date conversion when using APPEND FROM but, I am unsure whether; a) this is the case and; b) if so, has this been "corrected" in VFP7/8.
>
>Any tips very much appreciated.
Gary,
AFAIK append from (CSV) is problematic. Remove the first line (headers) and then do a delimited type append.
Cetin