Public Function Read_Text_File() As ADODB.Recordset Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset Dim conn As ADODB.Connection Set conn = New ADODB.Connection conn.Open "DRIVER={Microsoft Text Driver (*.txt; *.csv)};" & _ "DBQ=" & App.Path & ";", "", "" rs.Open "select * from [test#txt]", conn, adOpenStatic, _ adLockReadOnly, adCmdText Set Read_Text_File = rs Set rs = Nothing Set conn = Nothing End FunctionPrivate Sub cmdReadTXT_Click() Set DataGrid1.DataSource = Read_Text_File End Sub test.txt文件内容Test,Test2 1,1 2, 2 3, 3 4, 4 5, 5 6, 6 7, 7 8, 8 9, 9 111,222
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
Dim conn As ADODB.Connection
Set conn = New ADODB.Connection
conn.Open "DRIVER={Microsoft Text Driver (*.txt; *.csv)};" & _
"DBQ=" & App.Path & ";", "", "" rs.Open "select * from [test#txt]", conn, adOpenStatic, _
adLockReadOnly, adCmdText
Set Read_Text_File = rs
Set rs = Nothing
Set conn = Nothing
End FunctionPrivate Sub cmdReadTXT_Click()
Set DataGrid1.DataSource = Read_Text_File
End Sub test.txt文件内容Test,Test2
1,1
2, 2
3, 3
4, 4
5, 5
6, 6
7, 7
8, 8
9, 9
111,222