converting .txt file to .dbf file

[krpst19]

I'm trying to convert a simple comma delimited text file to a database file(.dbf)(IV preferably). I can do this very easily in MS Excel but I don't believe I can automate Excel in UNIX with a shell.
thanks
K

 

[MikeLacey]

ftp the file to your pc first, should be easy to convert from there Mike
michael.j.lacey@ntlworld.com
Email welcome if you're in a hurry or something -- but post in tek-tips as well please, and I will post my reply here as well.

 

[mbr]

Hi,

searching for "txt2dbf" at "

http://www.google.de"

gives pleanty of possible solutions, e.g.:

dBase Tools
The tasks of the two tools txt2dbf and dbf2txt are the conversion of ASCII tables into dbase files and vice versa.

txt2dbf
Conversion of ASCII tables into dbase files. The current version 1.0.2 (9. February 1998) handles the field types character, integer and real. Field
delimiters can be specified on the command line:

txt2dbf 1.0.2, 09.09.98 by Frank Koormann
Usage: txt2dbf [{-Cn | -In | -Rn.d}] [-d delimiter] [-v] txt-file dbf-file

Specifying the target (dbf-file) is mandatory, because of binary writing ! The table can be read from a file (txt-file) or stdio.

dbf2txt
Conversion of dBase4 files into ASCII tables:

dbf2txt 0.5.2, 14.01.2000 by Frank Koormann
Usage: dbf2txt [-d delimiter] [-v] dbf-file

HTH, mbr

 

[krpst19]

Thanks for the help. I got the source code for it as is form the site, but I'm having trouble compiling it. Any thoughts?
K

 

[mbr]

Any error-messages?
mbr