Subject |
Re: importing csv file |
From |
Gaetano D. <gaetanoddRemoveThis@andThatHotmail.com> |
Date |
Thu, 3 Jun 2021 06:37:39 +1000 |
Newsgroups |
dbase.getting-started |
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.
|
|