On Error Resume next Dim strTmp as String Dim Ar Open "C:\22.txt" For Input As #1 While EOF(1) line input #1,strTmp '读取每行数据 ar=split(strTmp," ") '分解字符串 SQL="Insert into 表(姓名,年龄,性别,日期) values('" & ar(0) & "'," & ar(1) & ",'" & ar(2) & "','" & ar(3) & "')" con.execute sql wend close(1)
Dim strTmp as String
Dim Ar
Open "C:\22.txt" For Input As #1
While EOF(1)
line input #1,strTmp '读取每行数据
ar=split(strTmp," ") '分解字符串
SQL="Insert into 表(姓名,年龄,性别,日期) values('" & ar(0) & "'," & ar(1) & ",'" & ar(2) & "','" & ar(3) & "')"
con.execute sql
wend
close(1)