请教如何把txt文件导入到accsee数据库
请问怎么把txt文件导入到accsee数据库
txt文件内容为：
201208032217818
201208032217826
201208032217834
201208032217842
201208032217859
------解决方案--------------------
Dim conn As New OleDbConnection("provider=microsoft.jet.oledb.4.0; data source=D:\xxx.mdb")
conn.Open()
For Each item As String In Split(richTextBox1.Text, VbCrLf)
Dim cmd As New OleDbCommand("insert into [tb]([col1]) values('" + item & "')", conn)
cmd.ExecuteNonQuery()
Next
conn.Close()
txt文件内容为：
201208032217818
201208032217826
201208032217834
201208032217842
201208032217859
------解决方案--------------------
Dim conn As New OleDbConnection("provider=microsoft.jet.oledb.4.0; data source=D:\xxx.mdb")
conn.Open()
For Each item As String In Split(richTextBox1.Text, VbCrLf)
Dim cmd As New OleDbCommand("insert into [tb]([col1]) values('" + item & "')", conn)
cmd.ExecuteNonQuery()
Next
conn.Close()