DBF to ADO

From: "Gilles" <gilles@xxxxxxxxxxxx>
Date: Tue, 27 Sep 2005 10:47:52 -0400

I have to merge several DBF tables (same structures, no index) into an ADO
table with a different structure. But I only want to merge records which do
not exist in the ADO table (criteria based on 2 fields).
What is the fastest way?

Gilles

.

Follow-Ups:
- Re: DBF to ADO
  - From: Gilles

Prev by Date: Re: MS ACCES DELPHIE MASTER/SLAVE PROBLEM
Next by Date: Select Max(col name) Expr1000
Previous by thread: MS ACCES DELPHIE MASTER/SLAVE PROBLEM
Next by thread: Re: DBF to ADO
Index(es):
- Date
- Thread

Relevant Pages

Using a Select Query to build a MDB table from a Fox table
... My ADO knowledge is limited and I'm not sure how a DBF table responds compared to an MDB table. ... This is a common SQL syntax but it fails here ...
(microsoft.public.fox.helpwanted)
Re: DBF to ADO
... I used the TTable.BatchMove with the batAppendUpdate mode to create a new ... DBF table that holds all the records. ... Gilles ... >I have to merge several DBF tables into an ADO ...
(borland.public.delphi.database.ado)
Re: BDE and ADO
... I would like to insert all the records from ADO into ... > DBF using SQL ... If transfer records from DBF to ... I didn't checked the syntax, ...
(borland.public.delphi.database.ado)
BDE and ADO
... I have two databases. ... I would like to insert all the records from ADO into DBF using SQL ... If transfer records from DBF to DBF, ...
(borland.public.delphi.database.ado)
Copying VFP 8 tables to an Access MDB
... I was able to do so but my ADO knowledge is limited. ... 'I would like to replicate the dbf in an MDB with the following but I get a syntax error. ... This is a common SQL syntax but it fails in ADO. ...
(microsoft.public.vb.database)