Function GetString(ByVal inputVal As Integer, str As String) As String
Dim i As Long Dim tmpstr As String Dim s As Integer For i = 1 To inputVal s = InStr(str, ",")
tmpstr = Left(str, s - 1) str = Trim(Mid(str, s + 1))
Next i GetString = tmpstr
End Function 先用FSO打开你的文件,要一行一行的读 再用以上函素,就可以取得你要的字符串,提交到相应的字段即可。INPUT方法也行。(小草的)
Open "g:\1.txt" For Input As #1 Do Until EOF(1) Line Input #1, infor '然后是字符串处理,把infor(04110 2001-08-17 0600113602 1 20 0 )分割成str1,str2,str3,str4.str5,str6 sql2 = "insert into table1 (字段1,字段2,字段3,字段4,字段5,字段6) values ('" & str1 & "','" & str2 & "','" & str3 &"','" & str4 & "','" & str5 & "','" & _ str6 & "')" Set rsd2 = DataEnvironment1.cn.Execute(sql2) Loop
不用分割了
Open "YourFileName.txt" For Input As #1Do WHILE NOT EOF(1) Line Input #1, strLine strLine="'" & trim(strLine) & "'" strLine=replace(strLine, " ","','") sqlStr = "insert into table1 (Field1,Field2,Field3,Field4,Field5,Field6) values (" & strLine & ")" Conn.Execute(sqlStr) Loop
Dim i As Long
Dim tmpstr As String
Dim s As Integer
For i = 1 To inputVal
s = InStr(str, ",")
tmpstr = Left(str, s - 1)
str = Trim(Mid(str, s + 1))
Next i GetString = tmpstr
End Function
先用FSO打开你的文件,要一行一行的读
再用以上函素,就可以取得你要的字符串,提交到相应的字段即可。INPUT方法也行。(小草的)
Do Until EOF(1)
Line Input #1, infor
'然后是字符串处理,把infor(04110 2001-08-17 0600113602 1 20 0
)分割成str1,str2,str3,str4.str5,str6
sql2 = "insert into table1 (字段1,字段2,字段3,字段4,字段5,字段6) values ('" & str1 & "','" & str2 & "','" & str3 &"','" & str4 & "','" & str5 & "','" & _ str6 & "')"
Set rsd2 = DataEnvironment1.cn.Execute(sql2)
Loop
Open "YourFileName.txt" For Input As #1Do WHILE NOT EOF(1)
Line Input #1, strLine
strLine="'" & trim(strLine) & "'"
strLine=replace(strLine, " ","','")
sqlStr = "insert into table1 (Field1,Field2,Field3,Field4,Field5,Field6) values (" & strLine & ")"
Conn.Execute(sqlStr)
Loop
如果用SQL语句先将TXT写到数据库中,后分解.....