How to join two DBF in VB?

Carmen

Member
May 5, 2001
38
0
0
I have two dbf files ( for example : data1.dbf and data2.dbf)
They have fields like:

data1.dbf : id_1, id_2, col3, col4,....
data2.dbf : D_1, D_2 , D_3

now, I want to join the two tables (add result fields to data2.dbf)
by two steps:
Step 1. using key id_1 and D_1 to join the tables
Step 2. using key id_1 and D_2 to join the tables

after that I want to remove all the unnecessary fields in data2.dbf,

how may I do this in VB?
Please tell me in details for each steps if possible....
Greatly appreciate for your help?