靠!一共20分还只给了18分!还不如免费送给你呢,2200个字符可能一文不值,但是程序不是这么收费的,首先我做了一个导库的小程序,把文本文件灌到数据库里面:加上这些应该有3000个字符了吧?那么平均167个字符换你一分!你个可恶分子,难怪英语学的这么好,其心狡诈也!!
Private Sub Command1_Click()
Dim num As Double
Dim Mystr As String
Dim DatabaseName As String
Dim Conn As New ADODB.Connection
Dim Rs As New ADODB.Recordset
Dim sql As String
Dim English As String
DatabaseName = App.Path & "\dic.mdb"
Dim fso As New FileSystemObject, txtfile, fil1 As File, ts As TextStream
Set txtfile = fso.OpenTextFile(CommonDialog1.FileName)
Set fil1 = fso.GetFile(CommonDialog1.FileName)
' 读取文件的内容。
Set ts = fil1.OpenAsTextStream(ForReading)
sql = "select * from 外贸"
Rs.Open sql, Conn, adOpenDynamic, adLockOptimistic
If ts.AtEndOfLine Then
MsgBox "结尾"
Else
Do While Not ts.AtEndOfStream
Mystr = Trim(ts.ReadLine)
If Len(Mystr) > 1 Then
myArray = Split(Mystr)
If UBound(myArray) > 1 Then
Rs.AddNew
English = ""
For i = 0 To UBound(myArray) - 2
English = English & myArray(i) & " "
Next
Rs("English") = English
Rs("type") = myArray(UBound(myArray) - 1)
Rs("chinese") = myArray(UBound(myArray))
End If
End If
Loop
End If
Rs.Update