Subject Re: csv import into dbf From Akshat Kapoor <akshat.kapoor@kapoorsons.in> Date Mon, 19 Aug 2024 11:44:36 +0530 Newsgroups dbase.getting-started Good morning Mervyn, > There is no standard for .csv files.  South Africa uses a comma for the > decimal point.  A .csv file created by Excel on my computer uses ; as > the field separator and dates are saved as ...;yyyy/mm/dd;... and > numeric values are saved as ...;1234,56;...  Dealing with these issues > is not difficult but not every .csv has these problems.  The answer was > to use switches in the library program so that they could be dealt with > if necessary.  Over the years, the number of switches needed grew. > append_from_csv.prg has reached the stage where it should be able to > deal with virtually any .csv file but if a new variation ever turns up > it is a simple matter to deal with it. It is for this precise reason that the program to import from excel was dumped. Ken had started it a few years ago and I with variety of data was the biggest hurdle in its successful completion. Regards Akshat