Create Database from TXT Format

Create Database from TXT (Txt2Db)

Description:
Txt2Db allows you to create a new database (MDB or DBF) from
a TXT formatted input file. Txt2Db will first analyze the input and
create a analyze file with the column names and data type (see DbAna for details)
By default Txt2Db writes the output to New.mdb
unless you specify a database with the -d option (like -d new.dbf).
The table name is extracted from the input file unless you specify
a table name (applies only for new MDB databases not to DBF).
The TXT data is loaded into the new database unless yoiu specify the -c option.
Txt2Db writes all diagnostics to a log file "logs/yyyymmdd/Txt2Db.log"
Note that In demo mode up to 100 records can be analyzed.

Syntax:
usage: Txt2Db [-csn] [-d{db}] -i[!]{in} [-t{tab}] [-f{font}]
-d = DATABASE: Specify new database filename (MDB or DBF) (default New.mdb)
-i = INPUT : Specify XML input file (! specified an analyze file directly)
-t = TABLE : Specify Table name (only used for new MDB databases)
-c =CREATEONLY: Dont load, just create empty database with structure)
-s = SILENT : Dont show diagnostics (XX Records written..)
-n = NOHEADER: Input has no header line for column names
(Logfile written to logs/YYYYMMDD/xml2db.log
Example: Txt2Db -i Employees.TXT

Example:
Txt2Db -d Emp.DBF -i Employees.TXT
Line 9: scanned Employees.TXT
Txt2Db: Create new Database 'Emp.DBF' from Employees_ana.txt

Created a new DBF database (Emp.DBF) with the structure matching Employees.TXT.
To load data into the new database use DbLoad

If the output database aleady exists the following prompt appears (unless you specify -s):

Logfile:
If you run this command on Feb 18th, 2001 the logfile would be created in:
logs/20010218/Txt2Db.log
INIT |13:35:03.438 |====== Opening c:/dbtkxml/logs/20010218/Txt2Db.log ======
DbTkXml |16:07:06.856 |ExecCmd: analyze Employees.TXT
Analyze |16:07:06.926 |Input=Employees.TXT,
Analyze |16:07:06.986 |9 Record(s) processed from 'Employees.TXT'++Result in 'Employees_ana.txt'
DbTkXml |16:07:07.026 |ExecCmd: CreateDb Employees_ana.txt|Emp.DBF