1 2 3 4 5 6 7 8
| strSQL = "INSERT INTO " & Mid(strNomFichier, 1, InStrRev(strNomFichier, ".")) & " (CLIIDCLI, CLICODCL, CLINOMBR, CLISIGCA, CLICALLE, CLITELEF, CLIDIRER, CLICODPO, CLICIUPR, CLINACIO, CLIDMOAD, CLICOPFA, CLIFILIA, CLITIPCL, CLIFALTA, CLIFBAJA, CLINUREL, CLIRAMA, CLICUENT, CLICARTE, CLIFACTU, CLISBAJA, "
strSQL = strSQL & "CLITIIVA, CLILIMCR, CLISIGCE, CLINIF12, CLIATENC, CLILMIVA) "
strSQL = strSQL & "VALUES (""" & strLigne(1) & """ , """ & strLigne(2) & """ , """ & strLigne(3) & """ , """ & strLigne(4) & """ , """ & strLigne(5) & """ , """ & strLigne(6) & """ , """ & strLigne(7) & """ , """ & strLigne(8) & """ , """ & strLigne(9) & """ , """ & strLigne(10) & """ , """ & strLigne(11) & """ , """ & strLigne(12) & """ , """ & strLigne(13) & """ , """
strSQL = strSQL & strLigne(14) & """ , """ & strLigne(15) & """ , """ & strLigne(16) & """ , """ & strLigne(17) & """ , """ & strLigne(18) & """ , """ & strLigne(19) & """ , """ & strLigne(20) & """ , """ & strLigne(21) & """ , """ & strLigne(22) & """ , """ & strLigne(23) & """ , """ & strLigne(24) & ""","""
strSQL = strSQL & strLigne(25) & """ , """ & strLigne(26) & """ , """ & strLigne(27) & """ ,""" & strLigne(28) & """);"
MsgBox strSQL
DoCmd.RunSQL strSQL |
Partager