Hello all I am trying to use the code CopyFromRecordset rs
but i found that only i can run this while it's sitting on a network drive. I need to loop and return each record what can i use instead of CopyFromRecordset rs? here is what I have now...Thanks in advance

For i = 1 To rs.Fields.Count

xlWs.Cells(currentRow, i).Value = rs.Fields(i - 1).Name


Next i

currentRow = currentRow + 1

'append recordset data to worksheet

xlWs.Cells(currentRow, 1).CopyFromRecordset rs