Set rs = New ADODB.Recordset
set rs = Read_Text_File '这里读取记录集
For i = 0 To rs.RecordCount - 1
conn.execute "insert into 你的表(字段1,字段2) values('"&rs.fields("a")&"','"&rs.fields("b")&"')"
rs.movenext
next
End Sub
绑定到datagrid我已经测试没有问题,以下代码是创建一个数组吗?
但是这样不能实现选择性的导入数据(如何实现选择datagrid中读入的文本数据行并导入数据库中请指教!)
dim rs as new adodb.recordset
set rs = Read_Text_File
rs.fields("a")
rs.fields("b")
rs.fields("c")
绑定到datagrid我已经给你写了,试试就知道了
dim rs as new adodb.recordset
set rs = Read_Text_File
rs.fields("a")
rs.fields("b")
rs.fields("c")
其实就是datagrid的选择问题了,将选择的多行数据放到数组中或者集合中
保存的时候,从数组或集合中得到数据插入的数据库
读取文本文件,填充到datagrid
文本文件test.txt
内容:test1,test2
1 ,2
3 ,4
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 Function
Private Sub cmdReadTXT_Click()
Set dgData.DataSource = Read_Text_File
End Sub