在access中,可以直接把文本文件导入到access中,对应的这个处理,在VB中如何用代码实现
急啊
哪位大虾帮帮忙
提供个例子
急啊
哪位大虾帮帮忙
提供个例子
解决方案 »
- 求教:利用VB ADO控件recordsource属性commandText中写入sql语句使DataGrid中显示特定内容
- 一个关于调用VC里面方法的问题
- 大家好~~~请大家我这个问题---编写一个远程登陆软件!!
- 讨论一下,这个是怎么做出来的?
- 如何制作winpim的界面???
- 2000下端口识别
- 關于如何提高VBAExcel速度的幾點心得,歡迎大家來發表意見和交流.感謝user_hj(office之友),
- 如何在VB中执行lnk或scf文件呢??
- INSTALL SHELD6.2问题:文件组如何使用自定义目录(script-defined folders)
- vb 6 逆向工程 谁会弄
- VB+SQL连接
- 串口数据问题
内容本身就是表
导入到access表中
Public cnnTemp As ADODB.Connection
Dim MyData As String
Dim N() As String
Private Sub Command1_Click()
Dim MyFSO As New FileSystemObject
Dim MyFile As File
Dim MyTS As TextStream
Dim lsData() As String
Dim lsTemp As String
Dim llCount As Long
Dim lsSql As String
Set MyFile = MyFSO.GetFile("c:\123.txt")
Set MyTS = MyFile.OpenAsTextStream(ForReading)
Do While MyTS.AtEndOfStream = False
lsTemp = MyTS.ReadLine
ReDim Preserve lsData(UBound(lsData) + 1)
lsData(UBound(lsData)) = lsTemp
Loop
MyTS.Close
Set MyFile = Nothing
Set MyFSO = Nothing
ReDim Preserve OutDate(UBound(lsData))
On Error GoTo err_Header
cnnTemp.BeginTrans
For llCount = 0 To UBound(lsData)
N = Split(lsdate(llCount), ",")
lsSql = "insert into myTable( 字段1,字段2,字段3,字段1,字段4,字段5,字段6,字段7,字段8) values("
lsSql = lsSql & "'" & N(0) & "',"
lsSql = lsSql & "'" & N(1) & "',"
lsSql = lsSql & "'" & N(2) & "',"
lsSql = lsSql & "'" & N(3) & "',"
lsSql = lsSql & "'" & N(4) & "',"
lsSql = lsSql & "'" & N(5) & "',"
lsSql = lsSql & "'" & Left(N(6), 2) & "',"
lsSql = lsSql & "'" & Right(N(6), 2) & "')"
cnnTemp.Execute lsSql
Next
cnnTemp.CommitTrans
Exit Sub
err_Header:
cnnTemp.RollbackTrans
MsgBox "插入数据错误", vbOKOnly
End SubPrivate Sub Form_Load()
MyData = App.Path & "\ACC.mdb"
Set cnnTemp = New ADODB.Connection
With cnnTemp
.Provider = "microsoft.jet.oledb.4.0"
.Open MyData
End With
End Sub