把SQL-SERVER的中的表导为一张Excel表的时候小表可以,大表程序就死了。程序代码都没有问题,代码是否哪个地方需要改动??
具体代码如下:
引用ADO
Private Sub Form_Load()
Dim mycon As New ADODB.Connection
Dim myres As New ADODB.RecordsetWith mycon
.ConnectionString = "Provider=SQLOLEDB.1;" & _
"Integrated Security=SSPI;" & _
"Persist Security Info=False;" & _
"Initial Catalog=Northwind;" & _
"Data Source=."
.Open
End With
With myres
.CursorLocation = adUseClient
.CursorType = adOpenDynamic
.LockType = adLockOptimistic
'下面的表如果换成一张大表,如orders表程序就像是死循环,高手点解,在线等!
.Open "employeeterritories", mycon, , , adCmdTable
End WithDim i As Integer, j As Integer
Dim myexcel As New Excel.Application
Dim mybook As New Excel.Workbook
Dim mysheet As New Excel.Worksheet
Set mybook = myexcel.Workbooks.Add '添加一个新的BOOK
Set mysheet = mybook.Worksheets.Add '添加一个新的SHEET
Do While Not myres.EOF
For j = 1 To myres.Fields.Count
mysheet.Cells(myres.AbsolutePosition, j) = myres.Fields.Item(j - 1).Value
Next j
myres.MoveNext
Loop
myexcel.Visible = True
mybook.SaveAs ("c:\a.xls") '保存文件
myexcel.Quit '退出EXCEL
Set mysheet = Nothing
Set mybook = Nothing
Set myexcel = Nothing
End Sub
具体代码如下:
引用ADO
Private Sub Form_Load()
Dim mycon As New ADODB.Connection
Dim myres As New ADODB.RecordsetWith mycon
.ConnectionString = "Provider=SQLOLEDB.1;" & _
"Integrated Security=SSPI;" & _
"Persist Security Info=False;" & _
"Initial Catalog=Northwind;" & _
"Data Source=."
.Open
End With
With myres
.CursorLocation = adUseClient
.CursorType = adOpenDynamic
.LockType = adLockOptimistic
'下面的表如果换成一张大表,如orders表程序就像是死循环,高手点解,在线等!
.Open "employeeterritories", mycon, , , adCmdTable
End WithDim i As Integer, j As Integer
Dim myexcel As New Excel.Application
Dim mybook As New Excel.Workbook
Dim mysheet As New Excel.Worksheet
Set mybook = myexcel.Workbooks.Add '添加一个新的BOOK
Set mysheet = mybook.Worksheets.Add '添加一个新的SHEET
Do While Not myres.EOF
For j = 1 To myres.Fields.Count
mysheet.Cells(myres.AbsolutePosition, j) = myres.Fields.Item(j - 1).Value
Next j
myres.MoveNext
Loop
myexcel.Visible = True
mybook.SaveAs ("c:\a.xls") '保存文件
myexcel.Quit '退出EXCEL
Set mysheet = Nothing
Set mybook = Nothing
Set myexcel = Nothing
End Sub
解决方案 »
- ActiveReports || Error 5000 : Error in processing report. [ Extended Info:用户 'sa' 登录失败。]
- 在自定义控件如何给多个相同控件增加属性?
- 急急急
- 500分 快捷键设置?
- 大家好,我是个初学者,我想跟您交流一下关于ADO的问题(急~~~在线等)
- 谁有支持XP样式的菜单控件
- 如何在mshflexgrid上单击时,记录指针也随着变化呢??
- 一个非常简单的SQL SERVER查询语句。。
- 谁能把这个问题解决了1000分奉上!!关于VB开发pdf浏览器的问题!
- 100M网络硬盘半年免费试用!
- 建ACCESS2000数据库表时库结构名称用中文好还是字母代码好
- 有关SQLSERVER ORACLE 的问题?
SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\test.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactions
SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\test.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactions
For i = 1 To myres.RecordCount
For j = 1 To myres.Fields.Count
’使用下面的Fields属性是不是有些不妥,有没有其他的属性来获取对应的值
mysheet.Cells(myres.AbsolutePosition, j) = myres.Fields.Item(j - 1).Value
If (myres.AbsolutePosition * j) Mod 500 = 0 Then
DoEvents
End If
Next j
myres.MoveNext
Next i