如何把dbf文件转化为mdb文件,为什么下面这句行不通?
————————————————
Private Sub Command1_Click()
Dim cnn As New ADODB.Connection
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\user\My Documents;Persist Security Info=False;Extended Properties=dBASE IV"
cnn.Execute ("select * into [;DATABASE=C:\Documents and Settings\user\My Documents\temp.mdb].[temp] from [aa]")
cnn.Close
End Sub
————————————————
Private Sub Command1_Click()
Dim cnn As New ADODB.Connection
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\user\My Documents;Persist Security Info=False;Extended Properties=dBASE IV"
cnn.Execute ("select * into [;DATABASE=C:\Documents and Settings\user\My Documents\temp.mdb].[temp] from [aa]")
cnn.Close
End Sub
foxpro 的 free table 与 database table 的格式也是有一点区别的。要调用正确的驱动程序才行。