Private Sub Command1_Click()
Dim db1 As Database
Set db1 = OpenDatabase("c:\db\po_print.mdb")
Dim rec As Recordset
Set rec = db1.OpenRecordset("select * from PURCHASE_REQ")
Dim session As Object
Dim db As Object
Dim view As Object
Dim doc As Object
Set session = CreateObject("notes.notessession")
Set db = session.GetDatabase("cnm1/wuscn", "wuscnap\mainpurch.nsf")
Set view = db.GetView("daxing")
Set doc = view.GetFirstDocument
Dim ss As Date
Dim s1 As Variant
Dim s2 As Variant
Dim s3 As Variant
Dim s4 As Variant
Dim s5 As Variant
Dim s6 As Variant
Dim s7 As Variant
Dim s8 As Variant
Dim s9 As Variant
Dim s10 As Variant
Dim s11 As Variant
Dim TEST As String
xlapp.Selection.Font.Size = 9
xlapp.Selection.NumberFormatLocal = "@" '设置纯文本,避免对数值做科学计数处理
'自动调整列宽
If FisAutoFit Then
xlapp.Selection.Columns.AutoFit
For i = 1 To cols+1
xlApp.Range(xlSheet.Cells(1,i), xlSheet.Cells(1,i)).Select
If xlapp.Selection.ColumnWidth > 25 Then
xlapp.Selection.ColumnWidth = 25 End If
Next
End If
xlApp.Range(xlSheet.Cells(1,1), xlSheet.Cells(rows-1,cols+1)).Select
'xlEdgeLeft:xlEdgeRight:xlEdgeTop:xlEdgeBottom:xlInsideHorizontal:xlInsideVertic al分别为 1,2,3,4,7,8
If FisShowGridLine Then '显示表格边线
For i = 1 To 8
Select Case i
Case 5, 6 : '5,6是斜线
Case Else
With xlapp.Selection.Borders( i )
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
End Select
Next
End If
'引用 Microsoft ActiveX Data Objects 2.X Library
Private Sub Command1_Click()
Dim cn As New ADODB.Connection
cn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=jtaf;Password=登陆密码;Initial Catalog=sql里的数据库;Data Source=sql服务器别名或IP"
cn.CursorLocation = adUseClient
cn.Open
'导入Excel用下面这句:
cn.Execute("insert into OpenRowSet('microsoft.jet.oledb.4.0','Excel 8.0;hdr=yes;database=c:\Test.xls;','select * from [Sheet1$]') select top 25 * from table1")
'导入Access用下面这句:
'cn.Execute ("insert into OpenRowSet('microsoft.jet.oledb.4.0',';database=c:\Test.mdb','select * from 表1') select top 25 * from table1")
cn.Close
Set cn = Nothing
End Sub