Click here to Skip to main content
14,741,130 members

Comments by Sams13 (Top 2 by date)

Sams13 8-Jul-13 4:01am View
   
I am asking if there are a better way to insert data from resultSet into sql table rather than using the looping

Do While rs.EOF = False
cmdCommand.CommandText = "INSERT INTO tblAccount(FULL_NAME) VALUES ( '" & rs.Fields(0).Value & "')"
cmdCommand.Execute (cmdCommand)
rs.MoveNext
Loop
Sams13 2-Jul-13 1:55am View
   
Thank you. It works