急寻帮助! txt文件导入ACCESS中以及MSFlexGrid数据导出到txt文件中????
我自己写了下,txt文件数据比较多,执行效率低下
请教大家有没好的方法
我自己写了下,txt文件数据比较多,执行效率低下
请教大家有没好的方法
解决方案 »
- 高手请进,毕生碰到最难的树型链表(!!!)
- 有200分的VB旧问题,非高手不可
- 关于打包问题的求教.每次打包时都会打上一个mdac_typ.exe,安装时也装一遍,可是我的系统是win xp呀,能否不装呀?
- 怎么通过代码控制excel中的某一个单元格可编辑,其余的都不能编辑?寻帮忙!!
- 求扩充控件功能的方法、思路?
- 使用Vb对oracle数据库操作可以使用ADO和Dadagrid控件吗
- 已知網絡上電腦的名稱和IP如何獲得它的網卡MAC地址? 很急!!!
- 在注册表被网站锁住后,要用把一些内容导进去,就可以打开了,我给忘了!!这些内容谁知道?
- VB6.0+ACCESS2000使用ado的错误
- 在vb中怎么实现象windows资源管理器一样,拖动中间的框能够使左右的控件宽度自适应的改变?
- msFlexGird控件数据与text控件
- 动态加载菜单的问题
Screen.MousePointer = vbHourglass
Dim intFreeNumber As Integer
Dim Conn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim rsArray() As String, fdArray() As String
Dim i As Long, j As Long
intFreeNumber = FreeFile() Open App.Path & "\MCZ-2004-08-21-灯丝电压(0001)X-DJ.txt" For Binary As #intFreeNumber
Do While Not EOF(intFreeNumber)
strTemp = Input(intFreeNumber, #intFreeNumber)
strfile = strfile & strTemp
Loop
Close #intFreeNumber
Set Conn = New ADODB.Connection
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\MC.mdb;Persist Security Info=False"
Set rs = New ADODB.Recordset
rs.CursorLocation = adUseClient
''' rs.Open "select * from 灯丝电压 where 时间=''", Conn, adOpenStatic, adLockBatchOptimistic, 1
rs.Open "select * from 灯丝电压 order by 时间", Conn, adOpenStatic, adLockBatchOptimistic, 1
rsArray = Split(strfile, vbCrLf)
For i = 0 To UBound(rsArray)
fdArray = Split(rsArray(i), ",")
'For j = 0 To 1
rs.AddNew
rs(0).Value = Trim(fdArray(0))
rs(1).Value = Trim(fdArray(1))
'Next j
Next i
rs.UpdateBatch
Set rs = Nothing
Screen.MousePointer = vbDefault
MsgBox CStr(i) & "行记录从文本文件中导入数据库!"
Exit Sub
End Sub'OutDataToText
'将MsFlexGrid控件中显示的内容输出到文本文件
Public Sub OutDataToText(Flex As MSFlexGrid)
Dim s As String
Dim i As Integer
Dim j As Integer
Dim k As Integer
Dim strTemp As String
On Error GoTo Ert
Me.MousePointer = 11
On Error Resume Next
DoEvents
Dim FileNum As Integer
FileNum = FreeFile
Open "d:\aa.txt" For Output As #FileNum
With Flex
k = .Rows
For i = 0 To k - 1
strTemp = ""
For j = 0 To .Cols - 1
DoEvents
strTemp = strTemp & .TextMatrix(i, j) & ","
Next j
Print #FileNum, Left(strTemp, Len(strTemp) - 1)
Next i
End With
Close #FileNum
Me.MousePointer = 0
MsgBox "导出成功"
Ert:
MsgBox Err.Description
Me.MousePointer = 0
End Sub