1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| cmd3.CommandText = " INSERT INTO tbl_list_function ( ScopeFunction ) VALUES ('" & xlSheet2.Range("D16") & "');"
cmd3.Execute , , adCmdText
cmd2.CommandText = " INSERT INTO tbl_list_project ( NameProject ) VALUES ('" & xlSheet2.Range("G16") & "');"
cmd2.Execute , , adCmdText
cmd.CommandText = " INSERT INTO tbl_declaration ( FunctionID ) " & _
" SELECT FunctionID " & _
" FROM tbl_list_function " & _
" WHERE tbl_list_function.ScopeFunction = '" & xlSheet2.Range("D16") & "'"
cmd.Execute , , adCmdText
cmd.CommandText = " UPDATE tbl_declaration INNER JOIN tbl_list_project ON tbl_declaration.ProjectID = tbl_list_project.ProjectID SET tbl_declaration.ProjectID = tbl_list_project.ProjectID WHERE tbl_list_project.NameProject = '" & xlSheet2.Range("G16") & "';"
cmd.Execute , , adCmdText |
Partager