here is the code
trying to insert two line in same time
by the way one line is working but when trying to add another line it give error 3137
"INSERT INTO test_table_transactions (T_Account_Number ,T_acc_sub_number,branch_id)" & _
" VALUES ('" & Account_Num & "','" & Thirdparty_id & "', '" & branch_id & "'), " & _
" ('" & Account_Num_2 & "',NULL, '" & branch_id_2 & "') ; "
trying to insert two line in same time
by the way one line is working but when trying to add another line it give error 3137
"INSERT INTO test_table_transactions (T_Account_Number ,T_acc_sub_number,branch_id)" & _
" VALUES ('" & Account_Num & "','" & Thirdparty_id & "', '" & branch_id & "'), " & _
" ('" & Account_Num_2 & "',NULL, '" & branch_id_2 & "') ; "