If this is a one-time import, my suggestion probably won't help, but if
this is functionality that you need to build into your program (and you
are developing in Delphi), you might consider looking at Topaz
<http://www.softsci.com/p-topaz.htm> . It's a dBase library that has
been around for maybe 20 years or so. It's a very mature product with
excellent documentation. I used it for many years before I found
Firebird.
Jack

--- In firebird-support@yahoogroups.com, "rick_roen" <rick@...> wrote:
>
> I am having a frustrating time importing dBase tables into Firebird
using OCBC. I know this is a long shot, but perhaps it will trigger
some advise from someone who has faced this problem.
>
> Net ODBC connection string = Driver={{Microsoft dBASE Driver
(*.dbf)}};DriverID=277;Exclusive=No;Deleted=1;Dbq=<folder name>
>
> ( I have also tried Deleted=0; and left Deleted out altogether)
>
> Query = Select * from [Invoic~1] where Invoicenum = 1234.
>
> This works most of the time, but when the FIRST row of the result set
is marked Deleted in dBase, nothing is returned. If the second row is
marked Deleted, the other rows are returned.
>
> For those not familiar with the dBase table structure, a deleted row
exists in the table until is is Packed (actually removed). Until then it
is marked as deleted in the row header, but it is still in place.
>
> Seems like a bug in the ODBC driver, but I haven't been able to find
anything on the web about this.
>
> Does this sound familiar to anyone?
>
> If not, can someone recommend a dBase ODBC ng?
>
> Regards,
>
> Rick
>



[Non-text portions of this message have been removed]