본문 바로가기

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

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