我是从客户端向服务器端插入的。
For I = 2 To ObjSheet.UsedRange.Rows.Count
DoEvents
StrSql = StrSql & "Insert into tablename (filed1,field2,field3,field4,field5,field6,field7,field8) values ("
StrSql = StrSql & "'" & IntUseID & "',"
For J = 1 To 8
If J < 8 Then
StrSql = StrSql & "'" & ObjSheet.Cells(I, J).Value & " ',"
Else
StrSql = StrSql & "'" & ObjSheet.Cells(I, J).Value & " '"
End If
Label8.Caption = I - 1
Next J
StrSql = StrSql & ");"
ObjConn.Execute StrSql
Next I
For I = 2 To ObjSheet.UsedRange.Rows.Count
DoEvents
StrSql = StrSql & "Insert into tablename (filed1,field2,field3,field4,field5,field6,field7,field8) values ("
StrSql = StrSql & "'" & IntUseID & "',"
For J = 1 To 8
If J < 8 Then
StrSql = StrSql & "'" & ObjSheet.Cells(I, J).Value & " ',"
Else
StrSql = StrSql & "'" & ObjSheet.Cells(I, J).Value & " '"
End If
Label8.Caption = I - 1
Next J
StrSql = StrSql & ");"
ObjConn.Execute StrSql
Next I
解决方案 »
- 不能写在module里???
- 高手请进,真是一个让人烦燥的问题 mciSendString
- datareport中如何设置换行?
- VB高手都来看看!LogonUser 函数的使用
- 谁有好看的VB窗体的代码或者控件下载啊?
- 新手,刚学编程,刚学api不知道如何使用,为什么不对····在线急··············100分不要白不要,不够再加
- vb 中的问题!
- 急!简单问题.UP有分.为什么第2次掉用,提示:"..var.. no set...?"
- VB6,怎样播放3GP/MP4文件(100分)
- VB用什么来获取当前插入了视频卡
- 关于数字金字塔的算法问题,高手请进!!!!!!
- sql统计问题,来者有分!
;User ID=Admin;Password=;Extended properties=Excel 5.0')...sheet1$