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