如题
解决方案 »
- VB是语言吗?还是类库?
- VB窗体中怎么打印
- 高手来帮忙啊!!关于如何创建数据库,求一简单点的例子!!谢谢~!
- 谁有ADSI25.chm这个帮助?
- vb 怎么修改内存地址啊?
- 请问用vb 角本打开ie ,我想不现上面的工具拦,命令要怎么写呀,谢谢
- 问一个很弱的问题:Excel的vb宏中怎么样把一个Integer转换成string?(在线等待)
- 难题!寒风跪地裸求!
- 请教大虾!如何打开一个超文本文件,对其<font>进行替换成[font]
- 请大家推荐一本学习VB+SQLSERVER的书,急用谢谢。
- ActiveX控件如何才能获取浏览器(打开的网页调用该控件)的地址(急!!,可加分)
- 'vb6下dataEnvironment和dataReport刷新数据问题
Set a = New Excel.Application
a.Visible = True
a.Workbooks.Add
http://www.csdn.net/develop/read_article.asp?id=14952
'Excel对象的使用(将Access中的数据导入到一个新建的Excel文件中)
'========================================================
Private Sub Form_Load()
Dim I, J As Long
Dim conn As ADODB.Connection
Dim rst As ADODB.Recordset
Set conn = New ADODB.Connection
Set rst = New ADODB.Recordset
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\db1.mdb;Persist Security Info=False"
conn.Open
rst.CursorLocation = adUseClient
rst.Open "select * from tableabc", conn, adOpenDynamic, adLockOptimistic
Dim MyApp As Excel.Application
Dim MyBook As Excel.Workbook
Dim MySheet As Excel.Worksheet
Set MyApp = CreateObject("Excel.Application")
MyApp.Visible = False
Set MyBook = MyApp.Workbooks.Add()
Set MySheet = MyBook.Worksheets(1)
J = 1
Do Until rst.EOF
For I = 1 To rst.Fields.Count
MySheet.Cells(J, I) = rst.Fields(I - 1)
Next
rst.MoveNext
J = J + 1
Loop
MyBook.SaveAs "C:\11.xls"
MyApp.Quit
Set MyApp = Nothing
rst.Close
Set rst = Nothing
Set conn = Nothing
End Sub
DIm sql as string
Dim DaoT As dao.Database
Set DaoT = Workspaces(0).OpenDatabase("DB")
Sql = "SELECT * INTO [Excel 8.0;DATABASE="Name"].[表名] FROM [DB表名] "
DaoT.Execute sql
Set db1 = DBEngine.OpenDatabase("数据库名")
db1.execute("Select * into my in '文件名' 'excel 5.0;' from 表名")
db1.close