Subject Re: importing csv file From Mustansir Ghor <mustan31@hotmail.com> Date Fri, 04 Jun 2021 12:10:02 -0400 Newsgroups dbase.getting-started Dear Gaetano Thank you. Yes it was addition of DELIMITED word that made the difference. The file that being imported is nothing but file genetated from SDK of Biometric device. I wish one day I could capture data directly from device. Best Regards Mustansir Gaetano D. Wrote: > On 3/06/2021 05:56, Mustansir Ghor wrote: > > Dear All > > > > Is there a way to import csv file into dbf table > > > > Best Regards to all > > > > Mustansir > > 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. > > -- > Gaetano. >