Dim rs As Recordset
Set rs = New ADODB.Recordset
rs.Open "select * from info", strconn + App.Path + "\novels.mdb", 3, 3
rs.AddNew
rs("title") = Title
rs("classify") = classify
rs("publisher") = publisher
rs("pdate") = CDate(pdate)
rs("edate") = CDate(edate)
rs("lcontent").AppendChunk (lcontent)
rs.Update
rs.Close
Set rs = Nothing
字段设置成二进制或long text字段。
Set rs = New ADODB.Recordset
rs.Open "select * from info", strconn + App.Path + "\novels.mdb", 3, 3
rs.AddNew
rs("title") = Title
rs("classify") = classify
rs("publisher") = publisher
rs("pdate") = CDate(pdate)
rs("edate") = CDate(edate)
rs("lcontent").AppendChunk (lcontent)
rs.Update
rs.Close
Set rs = Nothing
字段设置成二进制或long text字段。
解决方案 »
- 上位机和单片机通讯
- vb6.0,鼠标右键的使用
- 二维数组下标越界? 找不出原因,高手进来帮看看
- VB打印条码的代码转asp.net方式,有哪位做过,请给个思路
- 我想在vba里面计算程序运行的精确时间,如何用systemtime
- 我是VB盲,想问大家一个比较简单的问题?
- 关于recordset对象问题
- 请问:怎样实现在圆柱形上面实现字的打印?
- 请问怎样控制摄像头拍照,并且要求对于拍得的照片不用经过存储可以直接处理?
- 没有人帮我吗 我的VB只能加载OCX的FILE 我不能用ADODB了吗 大家帮帮忙啊
- (高分相赠)局域网通过代理服务器与另一个局域网中的客户机做点对点的通讯!!!
- 如何把access和vb中的option连接起来呀,很急很急!谢谢各位啦!!!
的联结吗?
如果能的话
应该可以直接导入了
不用VB编
现在关键是如何连接文本文件?
请大家指教!
是不是程序需求?
如果是为了搭建数据库,直接用ACCESS导入就可以了。 如果是程序需要,可以在ODBC设置 microsoft text Driver驱动的dsn,
然后设置ado控件的data source为这个dsn.
Option Explicit
Private Sub cmdBrowse_Click()
cmdlg.FileName = txtFile.Text
cmdlg.ShowOpen
txtFile.Text = cmdlg.FileName
SaveSetting "VBdata", "LawCenter", "Filename", txtFile.Text
End SubPrivate Sub cmdStart_Click()
Dim Fs As New FileSystemObject
Dim fdPath As String
Dim fd As Folder
Dim fc As Files
Dim fl As File
Dim ts As TextStream
Dim strLine As String
Dim strField(1 To 11) As Variant
Dim iLoop As Integer
Dim db As Connection
Dim adoPrimaryRS As Recordset
Dim i As Long
cmdStart.Enabled = False
txtFile.Enabled = False
cmdBrowse.Enabled = False
Me.MousePointer = vbHourglass
Set db = New Connection
db.CursorLocation = adUseServer
db.Open "PROVIDER=Microsoft.Jet.OLEDB.3.51;Data Source=******"
Set adoPrimaryRS = New Recordset
adoPrimaryRS.Open "select isnull(max(pkNo),0) + 1 from LawCenter", db, adOpenForwardOnly, adLockReadOnly
i = adoPrimaryRS.Fields(0)
adoPrimaryRS.Close
adoPrimaryRS.Open "select * from LawCenter", db, adOpenStatic, adLockOptimistic
fdPath = Left(txtFile, InStrRev(txtFile.Text, "\") - 1) 'Len(txtFile.Text) -
Set fd = Fs.GetFolder(fdPath)
Set fc = fd.Files
pgbLaws.Min = 0
pgbLaws.Max = fd.Files.Count
pgbLaws.Value = 0
'On Error GoTo ErrLine
For Each fl In fc
'Debug.Print fl.Path
Restart: Set ts = Fs.OpenTextFile(fl.Path, ForReading, False)
Debug.Print fl.Path
With ts
For iLoop = 1 To 10
strField(iLoop) = Trim(.ReadLine)
If strField(iLoop) = vbNullString Then
strField(iLoop) = Null
End If
Debug.Print strField(iLoop)
Next iLoop
If IsNull(strField(1)) Or IsNull(strField(3)) Or IsNull(strField(7)) Then
Debug.Print fl.Path
Stop
End If
strField(11) = vbNullString
Do Until .AtEndOfStream
strField(11) = strField(11) & .ReadLine & "<br>"
Loop
strField(11) = Replace(strField(11), " ", " ")
If Not IsNull(strField(6)) Then
strField(6) = Left(strField(6), 4) & "-" & Mid(strField(6), 6, 2) & "-" & Mid(strField(6), 9, 2)
Debug.Print strField(6)
strField(6) = CDate(strField(6))
End If
If Not IsNull(strField(7)) Then
strField(7) = Left(strField(7), 4) & "-" & Mid(strField(7), 6, 2) & "-" & Mid(strField(7), 9, 2)
Debug.Print strField(7)
strField(7) = CDate(strField(7))
End If
If strField(8) = "有效" Then
strField(8) = True
Else
strField(8) = False
Debug.Print fl.Path
Stop
End If
Debug.Print i
With adoPrimaryRS
.AddNew
.Fields(0) = i
For iLoop = 1 To 11
.Fields(iLoop) = strField(iLoop)
Next iLoop
.Update
'On Error GoTo 0
DoEvents
End With
i = i + 1
skip: .Close
DoEvents
pgbLaws.Value = pgbLaws.Value + 1
End With
Next
adoPrimaryRS.Close
db.Close
cmdStart.Enabled = True
txtFile.Enabled = True
cmdBrowse.Enabled = True
Me.MousePointer = vbDefault
Exit Sub
ErrLine:
Debug.Print fl.Path
Debug.Print Err.Description
Stop
adoPrimaryRS.CancelUpdate
Err.Clear
ts.Close
GoTo Restart
' If Err.Number = -2147217887 Or Err.Number = -2147467259 Then
' adoPrimaryRS.CancelUpdate
' Debug.Print "Error"
' ErrCount = ErrCount + 1
' Resume Next
' Else
' Stop
' adoPrimaryRS.CancelUpdate
' Resume Next
' End If
End Sub
Private Sub Form_Load()
txtFile.Text = GetSetting("VBdata", "LawCenter", "Filename")
End Sub
我原来用FSO!不知道是否有更好的方法?