[RESOLVED] CopyFromRecordset in Range

[mutley]

Hi

Reading data from Oracle in Recordset, I must to export records to first sheet
where first row is header and others are data
The sheet already exists, How can I to export recordset from the second row of sheet in front

[brucevde]

CopyFromRecordset is a method of the Range object.

The following example is from the Help file.

This example copies the field names from a Recordset object into the first row 
of a worksheet and formats the names as bold. The example then copies 
the recordset onto the worksheet, beginning at cell A2. 

For iCols = 0 to rs.Fields.Count - 1
    ws.Cells(1, iCols + 1).Value = rs.Fields(iCols).Name
Next
ws.Range(ws.Cells(1, 1),  _
ws.Cells(1, rs.Fields.Count)).Font.Bold = True

ws.Range("A2").CopyFromRecordset rs

[mutley]

Thank you very much