网上找到一篇关于将数据从 Visual Basic 传输到 Excel 的方法其中:Set rs = conn.Execute("Orders", , adCmdTable)
这是把所有的表名为“orders” 的内容那出来 请问如果只要取这张表的某几个字段该怎么办?
内容如下:
'Create a Recordset from all the records in the Orders table
Dim sNWind As String
Dim conn As New ADODB.Connection
Dim rs As ADODB.Recordset
sNWind = _
"C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb"
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
sNWind & ";"
conn.CursorLocation = adUseClient
Set rs = conn.Execute("Orders", , adCmdTable)
'Create a new workbook in Excel
Dim oExcel As Object
Dim oBook As Object
Dim oSheet As Object
Set oExcel = CreateObject("Excel.Application")
Set oBook = oExcel.Workbooks.Add
Set oSheet = oBook.Worksheets(1)
'Transfer the data to Excel
oSheet.Range("A1").CopyFromRecordset rs
'Save the Workbook and Quit Excel
oBook.SaveAs "C:\Book1.xls"
oExcel.Quit
'Close the connection
rs.Close
conn.Close文章连接:http://support.microsoft.com/default.aspx?scid=kb;zh-cn;247412
这是把所有的表名为“orders” 的内容那出来 请问如果只要取这张表的某几个字段该怎么办?
内容如下:
'Create a Recordset from all the records in the Orders table
Dim sNWind As String
Dim conn As New ADODB.Connection
Dim rs As ADODB.Recordset
sNWind = _
"C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb"
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
sNWind & ";"
conn.CursorLocation = adUseClient
Set rs = conn.Execute("Orders", , adCmdTable)
'Create a new workbook in Excel
Dim oExcel As Object
Dim oBook As Object
Dim oSheet As Object
Set oExcel = CreateObject("Excel.Application")
Set oBook = oExcel.Workbooks.Add
Set oSheet = oBook.Worksheets(1)
'Transfer the data to Excel
oSheet.Range("A1").CopyFromRecordset rs
'Save the Workbook and Quit Excel
oBook.SaveAs "C:\Book1.xls"
oExcel.Quit
'Close the connection
rs.Close
conn.Close文章连接:http://support.microsoft.com/default.aspx?scid=kb;zh-cn;247412
解决方案 »
- vb怎么把一大段代码给注释掉
- createobject("excel.application") 总报加载错误 高手帮助
- 能不能使journalhook长期保存?
- 怪怪的问题:B、VC双料冠军请进:VB向VC传递多个参数的问题!!!
- VBSpript中定义类型得问题,各位帮帮忙......
- 关于SQL连接失败问题,请教各位专家
- 同行的朋友们,来看看把。我实在没有分了。谢谢帮忙。
- 呀来人呀!我受不了了呀!
- 时间函数问题,大家都来看看
- VB ftp服务端 源代码
- 各位高手:mediaplayer6 如何实现播放时静音?
- Form大小为300*200,Picture中的图片大小为1024*768,如何在FORM中平滑的移动Picture中的图片(无闪烁)。
还有一个问题:这样导出的只有数据 没有列名 能否把列名也一起导入excel呢?