● ADO : DB에 접속하고, 데이터를 조작하기위한 MS기술 Private Sub insert_Click()Dim CN As ADODB.ConnectionDim SQL As StringDim sprovider As Stringsprovider = "Provider=SQLOLEDB; Data Source= DB 서버주소; Initial Catalog = DB명; User Id=사용자ID;pwd=PW"Set CN = New ADODB.ConnectionCN.ConnectionString = sproviderCN.CursorLocation = adUseClientCN.ConnectionTimeout = 0CN.OpenCN.BeginTransSQL = "INSERT INTO VA_BANK..