定义两个DATA控件,DATA1连接到DBF上,DATA2连接到MDB上,
然后,
Data2.Recordset.MoveFirst
Data3.Recordset.MoveFirst
Do
If Data2.Recordset.EOF Then
Exit Do
Else
Data1.Recordset.AddNew
Data1.Recordset.Fields("DBF中的字段名") = Data2.Recordset.Fields("MDB中对映的字段名")
Data1.Recordset.Update
Data2.Recordset.MoveNext
End If
Loop
然后,
Data2.Recordset.MoveFirst
Data3.Recordset.MoveFirst
Do
If Data2.Recordset.EOF Then
Exit Do
Else
Data1.Recordset.AddNew
Data1.Recordset.Fields("DBF中的字段名") = Data2.Recordset.Fields("MDB中对映的字段名")
Data1.Recordset.Update
Data2.Recordset.MoveNext
End If
Loop
呵呵,写错名字了,更正一下,上面的不对。 Data1.Recordset.MoveFirst
Data2.Recordset.MoveFirst
Do
If Data1.Recordset.EOF Then
Exit Do
Else
Data2.Recordset.AddNew
Data2.Recordset.Fields("MDB中对映的字段名")=Data1.Recordset.Fields("DBF中的字段名")
Data2.Recordset.Update
Data1.Recordset.MoveNext
End If
Loop
Select * Into score From [DbaseIII;Database=c:\mydir].score.dbf
哪位知道呢?
多字段怎么办?
Data2.Recordset.Fields("MDB中对映的字段名1")=Data1.Recordset.Fields("DBF中的字段名1")
Data2.Recordset.Fields("MDB中对映的字段名2")=Data1.Recordset.Fields("DBF中的字段名2")
Data2.Recordset.Fields("MDB中对映的字段名n")=Data1.Recordset.Fields("DBF中的字段名n")
'一定要用 Microsoft.Jet.OLEDB.4.0,不要用 3.51,但 MDB 文件可以是 Access97
adoConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\XXX.mdb;Persist Security Info=False"
'adoConnection.Execute "SELECT * INTO CopyOfAnimals FROM animals IN ''[dBASE IV;DATABASE=d:\dbfs\];"
adoConnection.Execute "INSERT INTO CopyOfAnimals SELECT * FROM animals IN ''[dBASE IV;DATABASE=d:\dbfs\];"
'一定要用 Microsoft.Jet.OLEDB.4.0,不要用 3.51,但 MDB 文件可以是 Access97
adoConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\XXX.mdb;Persist Security Info=False"
'adoConnection.Execute "SELECT * INTO CopyOfAnimals FROM animals IN ''[dBASE IV;DATABASE=d:\dbfs\]"
adoConnection.Execute "INSERT INTO CopyOfAnimals SELECT * FROM animals IN ''[dBASE IV;DATABASE=d:\dbfs\]"
'一定要用 Microsoft.Jet.OLEDB.4.0,不要用 3.51,但 MDB 文件可以是 Access97
adoConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\db4.mdb;Persist Security Info=False"'playyuer
'adoConnection.Execute "SELECT * INTO CopyOfAnimals FROM animals IN ''[dBASE IV;DATABASE=d:\dbfs\]"
'adoConnection.Execute "INSERT INTO CopyOfAnimals SELECT * FROM animals IN ''[dBASE IV;DATABASE=d:\dbfs\]"'王国荣 也可以,但也一定要用 Microsoft.Jet.OLEDB.4.0,不要用 3.51,但 MDB 文件可以是 Access97
'adoConnection.Execute "SELECT * INTO CopyOfAnimals FROM [dBASE III;DATABASE=d:\dbfs\].animals.dbf"
adoConnection.Execute "INSERT INTO CopyOfAnimals SELECT * FROM [dBASE III;DATABASE=d:\dbfs\].animals.dbf"
执行到如下语句报错:数据引擎找不到对象animals!
adoConnection.Execute "INSERT INTO CopyOfAnimals SELECT * FROM animals IN ''[dBASE IV;DATABASE=d:\yl];"该怎么办?
adoConnection.Execute "SELECT * INTO CopyOfAnimals FROM [dBASE III;DATABASE=d:\dbfs\].animals.dbf"
'以后执行
adoConnection.Execute "INSERT INTO CopyOfAnimals SELECT * FROM animals IN ''[dBASE IV;DATABASE=d:\dbfs\]"
我就把分全加给你吧!
databasename.execute SQL
(SQL为你要执行的SQL语句)
我以前这样做过的