As you already know, Chris Eastwood's CodeGuru FTP Class
at http://codeguru.earthweb.com/vb/articles/1852.shtml
gives you a good start. Otherwise, this may help you on your way:
Code:
While (Not rs.EOF)
' granted it is overkill...
  Debug.Print rs(0)
  vTemp = rs(0)
  Debug.Print vTemp
  rs.MoveNext
Wend