Re: .dbf to oracle?

Jeff Hunter wrote in message <38d9593c_at_defiant.btitelecom.net>...
>
>I am trying to find out if anyone has a method to load a dBase file (.dbf)
>to oracle (on Solaris) without using a PC? I have a client that needs to
>automatically ftp a file and load it into their Oracle database without
>human intervention. Any hints?

The .DBF data file structure is fairly simply. The header contains the file (or table) definition, such as the column names and types. After the header, you then have the data blocks containing the rows. Once again, a fairly simple data structure (e.g. rowid, columnid, length, value or something in that vein).

Jeff, you should be able to write a C program to read a DBF file, without having to use dBASE software. If you are interested in the file format, please drop me an e-mail and will go and try and dig it out (I'm sure I still have it a file somewhere). Alternatively, try the web. I think there must be at least a few source programs available for processing DBF file. Finding one written in C and porting that to Unix should not be a major undertaking.

regards,
Billy Received on Thu Mar 23 2000 - 00:00:00 CST