导出EXCEL时,一行记录会导出成两行或三行问题
以下是我的源程序,当导出的数据值中有“OK”的时候,会自动导出到第二行,请高手指教其中错误。
Public Sub SQLtoEXCEL(tSQL As String, strFileName As String)
Dim objFileSystem As Object
Dim objExcelText As Object
Dim strTableString As String, i As Integer
Dim rst As rdoResultset
Dim strConn As String
On Error GoTo errtmp
If strFileName = "" Then Exit Sub
Set rst = CN.OpenResultset(tSQL, adOpenStatic, adLockOptimistic)
If rst.EOF = False Then
i = 0
For i = 0 To rst.rdoColumns.Count - 1
strTableString = strTableString & rst.rdoColumns(i).Name & Chr(9) '獲取字段名
Next i
strConn = strConn & rst.GetClipString(rst.RowCount) '字段名+數據庫的記錄
End If
rst.Close
Set objFileSystem = CreateObject("Scripting.FileSystemObject")
Set objExcelText = objFileSystem.createtextfile(strFileName, True)
objExcelText.writeline (strTableString)
objExcelText.writeline (strConn)
objExcelText.Close
Set objFileSystem = Nothing
MsgBox "已完成!", vbInformation
Exit Sub
errtmp:
MsgBox "请注意要导入的文件是否在使用!", vbInformation
End Sub