Re: DBF to ADO

From: "Gilles" <gilles@xxxxxxxxxxxx>
Date: Wed, 28 Sep 2005 09:10:17 -0400

I used the TTable.BatchMove with the batAppendUpdate mode to create a new
DBF table that holds all the records.

Is there a similar method that can be used wit ADO tables so that I don't
have to do a record by record check?

Gilles

>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
>

.

References:
- DBF to ADO
  - From: Gilles

Prev by Date: Pulling Thai Characters from Access
Next by Date: Thai Characters not pulling from Access, showing ????????
Previous by thread: DBF to ADO
Next by thread: Select Max(col name) Expr1000
Index(es):
- Date
- Thread

Relevant Pages

DBF to ADO
... I have to merge several DBF tables into an ADO ... Gilles ... Prev by Date: ...
(borland.public.delphi.database.ado)
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: 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)