Экспорт полей Запроса в лист Еexcel |
Run-time error 3601 Too few parametrs. Expected 1
Option Compare Database Private Sub Command2_Click() Dim rs As DAO.Recordset Dim db As Database Dim str As String Dim abc, abc1 As String Dim objXL As Object Dim objWB As Object Dim objWS As Object Set objXL = CreateObject("Excel.Application") Set objWB = objXL.Workbooks.Open("E:\testfile.xlsx") Set objWS = objWB.Worksheets("A") Set db = CurrentDb() str = "SELECT ID_Balance, SumOfA_001, SumOfA_005 FROM QueryTotalStart" Set rs = db.OpenRecordset(str) abc = rs("A_001") abc1 = rs("A_005") With objWS .Cells(3, 3).Value = abc .Cells(4, 3).Value = abc1 End With objXL.Visible = True End Sub
http://www.sql.ru/forum/1206911/eksport-poley-zaprosa-v-list-eexcel
Комментировать | « Пред. запись — К дневнику — След. запись » | Страницы: [1] [Новые] |