想要修改:
Private Sub Form_Load()
Dim Cnn As New ADODB.Connection
Dim rst As New ADODB.Recordset
Cnn.Open "Driver={Microsoft Text Driver (*.txt; *.csv)};" & "Dbq=d:\;" & "Extensions=asc,csv,tab,txt;"
rst.CursorLocation = adUseClient
rst.Open "Select * From 1.txt", Cnn, adOpenKeyset, adLockOptimistic, adcmdUnkown
Set DataGrid1.DataSource = rst
Set rst = Nothing
End Sub
Private Sub Form_Load()
Dim Cnn As New ADODB.Connection
Dim rst As New ADODB.Recordset
Cnn.Open "Driver={Microsoft Text Driver (*.txt; *.csv)};" & "Dbq=d:\;" & "Extensions=asc,csv,tab,txt;"
rst.Open "Select * From 1.txt", Cnn, adOpenStatic, adLockPessimistic
Set DataGrid1.DataSource = rst
End Sub