xb_import - Man Page

xb_import -t MyFile.DBF -i InputFile.txt -d |

xb_import -h

xb_import -v

xb_import imports data records from a delimited input file into an existing .DBF file.

The first record in the input file is required to be a list of field names in the same order as the data in the delimited input data file. Additionally the field names need to correspond to field names in the DBF table in order to be imported.

The fields in the input data file do not need to be in the same order as they are in the table but the field names need to match.

Fields that exist in the DBF table that are not included in the input data will be left blank. Fields that are in the input data that don't exist in the DBF table will be ignored.

The Xbase64 library provides various utility programs and a set of C++ classes for application  programming for reading, writing and updating DBF database files, NDX and MDX index files and DBT memo files. Version 4.x.x has been tested for compatability with dBASE III (TM), dBASE IV (TM) and dBASE 5 (TM) version data files and  indices *.DBF (data), *.NDX (single tag index), *.MDX (multi tag index) and *.DBT (memo). In RDBMS parlance, each *.DBF file would be a table.

-h,  -?,  --help

display help information.

-v,  --version

display version information.

-t MyFile.DBF

DBF file to import data to.

-i InputFile.csv

Input file of delimited text where the first line is a list of field names corresponding to fields in the DBF file to import.

-d |

Otional delimeter.  The default delimiter is a comma ",".

-q,  --quiet

quiet mode

*.DBF

Gary Kunkel <xdb-devel@lists.sourceforge.net>

xb_cfg_check(1), xb_clearix(1), xb_copydbf(1), xb_dbfutil(1), xb_deletall(1), xb_dumpdbt(1), xb_dumprecs(1), xb_execsql(1), xb_pack(1), xb_reindex(1), xb_tblinfo(1), xb_undelall(1)

<xdb-devel@lists.sourceforge.net>

xb_cfg_check(1), xb_clearix(1), xb_copydbf(1), xb_dbfutil(1), xb_deletall(1), xb_dumpdbt(1), xb_dumprecs(1), xb_execsql(1), xb_pack(1), xb_reindex(1), xb_tblinfo(1), xb_undelall(1).