Subject Re: importing csv file From Mervyn Bick <invalid@invalid.invalid> Date Thu, 3 Jun 2021 09:32:30 +0200 Newsgroups dbase.getting-started On 2021/06/02 22:37, Gaetano D. wrote: > Lookup the command "append from" in Help and you will find the answer. > > append from myfile.csv <delimited with ["]> REINDEX > > The reindex option is important for large files as it will prevent > updating the index for each and every row being added, instead it will > reindex only once after the append job has completed. > > If the data is delimited, e.g. because the data contains comma's, you > also need the <delimited with ["]> portion - replace the double quote > with whatever delimits the data, else you should leave that portion out. > [Append from <file.csv> delimited] works well but it has limitations. It doesn't work with what Microsoft calls tab delimited files but which are actually tab separated files. It will, in fact, not work where anything other than a comma is used as a separator.  It will not import into memofields and dates must be in the format ....,yyyymmdd,.....  i.e no delimiters and no separators in the actual date. The command handles the default delimiter " as a delimiter automatically.  If the .csv file uses a different delimiter, say a single quote, then the delimiter must be specified by adding [ with "'" ] to the command. Mervyn.