Subject Re: date problem in appending from Excel From Emeka Ossai <megameks@yahoo.com> Date Thu, 04 Mar 2021 15:31:56 -0500 Newsgroups dbase.getting-started Thank you so Ken. I will try this now. Emeka Ken Mayer Wrote: > On 3/4/2021 10:32 AM, Emeka Ossai wrote: > > Hello, > > > > 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' > > It is likely the date format needs to match what your current date > setting is. > > If it doesn't match, dBASE won't know how to interpret the value, as it > is really a string coming in from the CSV file. > > To see what your current setting is: > > ? set( "date" ) > > Compare the format against what is in the .CSV file. If it doesn't match: > > cOldDateFormat = set( "date" ) > set date "new date format string" // see help (help set date) > //perform the append ... > set date &cOldDateFormat. // reset date format > > Ken > > > > -- > *Ken Mayer* > Ken's dBASE Page: http://www.goldenstag.net/dbase > The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp > dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm > dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm