iteration movenext
I am trying to iterate through my database to return rows to excel but i only get a single row, here is my code:
objConn.Open "Driver={SQL Server};Provider=SQLOLEDB;data source=SQLSERVER;database=DB;Uid=sa;Pwd=pwd"
stSQL = "SELECT Name FROM Id"
objRS.Open stSQL, objConn
Do While objRS.EOF = False
ws.Cells(1, 1).Value = objRS.Fields(0).Value
objRS.MoveNext
Loop
thanks again.
|
