另類快速導(dǎo)出數(shù)據(jù)庫(kù)為EXCEL文檔

在網(wǎng)上的導(dǎo)出為 EXCEL文檔的方法大概是這樣的
    Dim 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 ’’添加一個(gè)新的BOOK
    Set mysheet = mybook.Worksheets.Add ’’添加一個(gè)新的SHEET
    ’’ For i = 1 To myres.RecordCount
    ’’ For j = 1 To myres.Fields.Count
    ’’ mysheet.Cells(i, j) = myres.Fields.Item(j - 1).Value
    ’’ If (i * j) Mod 500 = 0 Then
    ’’ DoEvents
    ’’ End If
    ’’ Next j
    ’’ myres.MoveNext
    ’’ Next i
     myexcel.Visible = True
     mybook.SaveAs (m_ExcelName) ’’保存文件
    這中方法沒(méi)什么錯(cuò)誤,但是如果數(shù)據(jù)量很大的話,麻煩就來(lái)了,出現(xiàn)程序長(zhǎng)時(shí)間不響應(yīng)
    關(guān)鍵是循環(huán),下給出我的代碼
    假設(shè)定義的記錄名為myres
    Dim myexcel As New Excel.Application
    Dim mybook As New Excel.Workbook
    Dim mysheet As New Excel.Worksheet
    Set mybook = myexcel.Workbooks.Add ’’添加一個(gè)新的BOOK
    Set mysheet = mybook.Worksheets.Add ’’添加一個(gè)新的SHEET
     myexcel.visible=true
    mysheet.Cells.CopyFromRecordset myres
    mybook.SaveAs (m_ExcelName) ’’保存文件
    利用這個(gè)代碼可以大大的縮短導(dǎo)出時(shí)間,8000多個(gè)紀(jì)錄用第一種方法大概需要2分多
    而用第二種方法只大概要4秒,可以親自試驗(yàn)一下,上述結(jié)果測(cè)試平臺(tái)為WIN98+EXCEL2000