我将ACCESS数据导入EXCEL中,其代码为:
Dim Conn As New ADODB.Connection
Dim Rs As New ADODB.Recordset
Dim ExcelApp As New Excel.Application
Dim WorkBookObj As Workbook
Dim SheetObj As Worksheet
Conn.ConnectionString = "Provider=Microsoft.jet.OLEDB.3.51;" & "Data Source=D:\txxy\转速表.mdb"
Conn.Open
Rs.Open "Select 显示转速,检测转速1,检测转速2,检测转速3,三次平均值,误差 From 转速表 where 转速表编号='" & Text2.Text & "'", Conn, adOpenKeyset, adLockOptimistic, adCmdText
Set WorkBookObj = ExcelApp.Workbooks.Open(App.Path & "\abc.xls")
Set SheetObj = WorkBookObj.Worksheets(1)
SheetObj.Range("A1").CopyFromRecordset Rs
Set SheetObj = Nothing
WorkBookObj.Save
WorkBookObj.Close
Set WorkBookObj = Nothing
'ExcelApp.Quit
'Set ExcelApp = Nothing
Rs.Close
Set Rs = Nothing
Conn.Close
Set Conn = Nothing
MsgBox "OK!请您打开abc.xls文件察看!"
ExcelApp.Visible = True
但存在以下几个问题:
1、没有表头 如 检测记录
2、数据导入到excel时如何控制数据的位置。
3、如何将abc.xls显示出来。
请各位大侠赐教,最好有代码.
[email protected]
Dim Conn As New ADODB.Connection
Dim Rs As New ADODB.Recordset
Dim ExcelApp As New Excel.Application
Dim WorkBookObj As Workbook
Dim SheetObj As Worksheet
Conn.ConnectionString = "Provider=Microsoft.jet.OLEDB.3.51;" & "Data Source=D:\txxy\转速表.mdb"
Conn.Open
Rs.Open "Select 显示转速,检测转速1,检测转速2,检测转速3,三次平均值,误差 From 转速表 where 转速表编号='" & Text2.Text & "'", Conn, adOpenKeyset, adLockOptimistic, adCmdText
Set WorkBookObj = ExcelApp.Workbooks.Open(App.Path & "\abc.xls")
Set SheetObj = WorkBookObj.Worksheets(1)
SheetObj.Range("A1").CopyFromRecordset Rs
Set SheetObj = Nothing
WorkBookObj.Save
WorkBookObj.Close
Set WorkBookObj = Nothing
'ExcelApp.Quit
'Set ExcelApp = Nothing
Rs.Close
Set Rs = Nothing
Conn.Close
Set Conn = Nothing
MsgBox "OK!请您打开abc.xls文件察看!"
ExcelApp.Visible = True
但存在以下几个问题:
1、没有表头 如 检测记录
2、数据导入到excel时如何控制数据的位置。
3、如何将abc.xls显示出来。
请各位大侠赐教,最好有代码.
[email protected]
解决方案 »
- 关于VB中DATAGRID动态隐藏列的问题
- 100分求助,此控件(Sgird2 OCX)如何在新工程中引用?内附控件下载地址和相关说明!
- 如何得到文件的修改用户
- 初学VB,主要是学数据库,请高手推荐几本书。
- 怎样在程序中得到win2000是否打上了sp2或sp4 !!!!!!!
- Excel报表问题,求救
- 求救:用VB创建word文档,并在其中建立表格,问如何控制表格的起始位置????
- 有没有好的办法检测到与局网中的机器是否连通?
- 关于利用WINSOCK控件共享或动态链接数据库的问题?
- 老板然我编一个打印发票的程序,有谁有将数字转化为中文大写的函数?
- CopyStructFromPtr问题
- 有使用installshield经验的大侠进来帮帮我呀
Dim objFileSystem As Object
Dim objExcelText As Object
Dim strTableString As String, i As Integer, strFileName As String
Dim pubConn As New ADODB.Connection
Dim rsTable As New ADODB.Recordset
Dim strConn As String
Dim strSQL As String strConn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=develop; password=12345;Data Source=ServerNmae"
pubConn.Open strConn
rsTable.CursorLocation = adUseClient
strSQL = "select top 10 * from gate_register"
rsTable.Open strSQL, pubConn, adOpenDynamic, adLockOptimistic
For i = 0 To rsTable.Fields.Count - 1
strTableString = strTableString & rsTable.Fields(i).Name & Chr(9) '獲取字段名
Next
strTableString = strTableString & rsTable.GetString '字段名+數據庫的記錄
cmDialog.CancelError = False
cmDialog.FileName = "FileName" '默認生成的文件名
cmDialog.DialogTitle = "Save Export File"
cmDialog.Filter = "Excel (*.xls)|*.xls|文本文件(*.DBF)|*.DBF|檔案文件(*.doc)|*.doc|所有文件(*.*)|*.*"
cmDialog.DefaultExt = "*.xls"
cmDialog.ShowSave
strFileName = cmDialog.FileName
Set objFileSystem = CreateObject("Scripting.FileSystemObject")
Set objExcelText = objFileSystem.createtextfile(strFileName, True)
objExcelText.writeline (strTableString)
objExcelText.Close
Set objFileSystem = Nothing
End Sub
你的程序不能完全控制数据的位置。