1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
|
Public Function SynchroBC_TITIA()
Dim ConnexionBDD As DAO.Database
Dim rsListingBC As DAO.Recordset
Dim sStrSql As String
Dim sSQLUpdate As String
sStrSql = "DELETE * FROM [#T_Extraction_Mvts]"
CurrentDb.Execute sStrSql
'jusqu'ici tout se passe bien, je purge ma table dans TRAVAIL.mdb avant l'import
Set ConnexionBDD = DBEngine.OpenDatabase(CheminBaseCreance) 'Ici je me connecte à BC.mdb
sStrSql = "SELECT * FROM [#T_Extraction_Mvts_BC]" 'Hop je recupere toutes les valeurs de la table voulu dans BC.mdb
Set rsListingBC = ConnexionBDD.OpenRecordset(sStrSql, dbOpenForwardOnly, dbReadOnly) 'ouverture du recordset
While Not rsListingBC.EOF
sSQLUpdate = "INSERT INTO [#T_Extraction_Mvts] (NumFacture, CCD, Ref, Montant, Date_Fact, SeuilRapprochement, RefSeq, Segment, ValiderExtraction)"
sSQLUpdate = sSQLUpdate & " VALUES ( " & rsListingBC("NumFacture") & ", " & """" & rsListingBC("CCD") & """" & ", " & """" & rsListingBC("Ref") & """" & ", " & """" & rsListingBC("Montant") & """" & ", " & """" & rsListingBC("Date_Fact") & """" & ", " & """" & rsListingBC("SeuilRapprochement") & """" & ", " & """" & rsListingBC("RefSeq") & """" & ", " & """" & rsListingBC("Segment") & """" & ", " & """" & rsListingBC("ValiderExtraction") & """"
sSQLUpdate = sSQLUpdate & ")"
Form_Formulaire_Acceuil.TextBox_DebugUpdate.Value = sSQLUpdate
CurrentDb.Execute sSQLUpdate 'voila j'ai l'impression que c'est la que ca peche un peu
rsListingBC.MoveNext
Wend
ConnexionBDD.Close
End Function |
Partager