Subject Re: date problem in appending from Excel
From Akshat Kapoor <akshat.kapoor@kapoorsons.in>
Date Fri, 5 Mar 2021 12:51:31 +0530
Newsgroups dbase.getting-started

Good Afternoon Emeka,

> I need your assistance.  I saved the file as a csv file. I am trying to append the data  from csv to dbase, but the date did not show at all. Other data showed except date.
>
> I used 'append from c:\bike\bikal.csv delimited'

I am using the following command
append from attendance.csv delimited with ","

The data in the csv is from a biometric attendance system.
The dates are in the format yyyy-mm-dd and the dates are inserted fine.

The biggest problem with dates is the formatting issue as pointed out by
Ken.

The safest format for import export is yyyy-mm-dd. There is no ambiguity
in this date format.
Regards
Akshat