Re: How to read DBF Files?

From: Alex Filonov <afilonov_at_yahoo.com>
Date: 19 Mar 2003 10:45:02 -0800
Message-ID: <336da121.0303191045.3c42e80e_at_posting.google.com>


"Ricardo" <_at_> wrote in message news:<3e787653$1_at_news.terra.com.br>...
> Is there a way that I can read, through PL/SQL, a DBF formated file, like
> Paradox ones?
>
> RDBMS Version 9.2.0
>
> Thanks
>
> Ricardo (Brazil)

There was a utility in Oracle V6 (DOS and OS/2 versions) and V7 (OS/2 version). It prepared a sqlloader control file based on the DBF file. It didn't work with Foxbase files though.
Actually, DBF files are fixed-length files. So if you spend some time, you'll be able to write sqlloader control file for particular DBF file. You'd need a separate control file for every structure of DBF. Received on Wed Mar 19 2003 - 19:45:02 CET

Original text of this message