我给你记下了,正在研究中。cy_nwau@163.com
Private Sub Command1_Click()
Dim oWord As Object
Dim oDoc As Object
Dim oRange As Object
Dim oConn As Object
Dim oRS As Object
Dim sTemp As String, i%
Set oWord = CreateObject("Word.Application")
oWord.Visible = True
Set oDoc = oWord.Documents.Add
Set oRange = oDoc.Range
Set oConn = CreateObject("ADODB.Connection")
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\房产管理系统\房产信息.mdb;Persist Security Info=False"
Set oRS = oConn.Execute("SELECT * FROM 楼房情况表")
Do Until oRS.EOF
For i = 0 To oRS.Fields.Count - 2
sTemp = sTemp & oRS.Fields(i).Value & ","
Next i
sTemp = sTemp & oRS.Fields(i).Value & vbCrLf
oRS.moveNext
Loop
oRange.Text = sTemp
oRange.ConvertToTable ",", , , , 1, , , , , , , , , True
End Sub
Private Sub Command1_Click()
' Declare our variables
Dim oWord As Word.Application
Dim oDoc As Word.Document
Dim oRange As Word.Range
Dim oConn As ADODB.Connection
Dim oRS As ADODB.Recordset
Dim sTemp As String
' Create an instance of Word
Set oWord = CreateObject("Word.Application")
' Show Word to the user
oWord.Visible = True
' Add a new, blank document
'Set oDoc = oWord.Documents.Add("d:\Remark.doc")
Set oDoc = oWord.Documents.Add
'Set oDoc = oWord.Documents.Open
' Get the current document's range object
Set oRange = oDoc.Range
' Create a new ADO connection
Set oConn = CreateObject("ADODB.Connection")
' Open our connect