Private Sub Command1_Click() Dim ret As String Dim ret0 as String Dim cn As ADODB.Connection Dim rs As ADODB.Recordset
Set cn = New Connection Set rs = New Recordset cn.CursorLocation = adUseClient cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\a.mdb;Persist Security Info=False" cn.Open rs.Open "select * from abcd ", cn, adOpenStatic, adLockBatchOptimistic
ret = Dir("d:\b\*.txt") Do Until ret = "" rs.AddNew rs!文件名 = ret Open "d:\b\" & ret For Input As #1 Line Input #1, ret0 Close #1 rs!第一行 = ret0 ret = Dir() Looprs.UpdateBatch rs.Close Set rs = Nothing cn.Close Set cn = NothingEnd Sub
Dim ret As String
Dim ret0 as String
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Set cn = New Connection
Set rs = New Recordset
cn.CursorLocation = adUseClient
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\a.mdb;Persist Security Info=False"
cn.Open
rs.Open "select * from abcd ", cn, adOpenStatic, adLockBatchOptimistic
ret = Dir("d:\b\*.txt")
Do Until ret = ""
rs.AddNew
rs!文件名 = ret
Open "d:\b\" & ret For Input As #1
Line Input #1, ret0
Close #1
rs!第一行 = ret0
ret = Dir()
Looprs.UpdateBatch
rs.Close
Set rs = Nothing
cn.Close
Set cn = NothingEnd Sub