VBA 기본 INSERT / UPDATE / SELECT DELETE

//INSERT

conn.Execute "INSERT INTO test.tsettb( name,texts) values('테스트', '테스트라고')"

    

//DELETE

conn.Execute "DELETE FROM test.tsettb WHERE idx = 1"

//UPDATE    

conn.Execute "UPDATE test.tsettb SET name = '업데이트 테스트'"

      

//SELECT

sSQL = "SELECT * FROM test.tsettb "

Create a recordset and set the CursorLocation property for record navigation

Set dbRecset = New ADODB.Recordset

dbRecset.CursorLocation = adUseClient

dbRecset.Open Source:=sSQL, ActiveConnection:=conn, CursorType:=adOpenForwardOnly, _

               LockType:=adLockReadOnly, Options:=adCmdText

피곤한 관계로 내일 세부적으로 보자.