1 2 3 4 5 6 7 8 9
| Public Sub ChangerSQL(prmNomRequete As String, prmNomTable As String)
Dim db As dao.Database: Set db = CurrentDb
Dim q As dao.QueryDef: Set q = db.QueryDefs(prmNomRequete)
q.SQL = "INSERT INTO TV ( [Date], Famille, libelle, lot, uv, dlc, bon, colis, poids, code, Nom, Douchage, sscc )SELECT [" & prmNomTable & "].Date, [" & prmNomTable & "].Famille, [" & prmNomTable & "].libelle, [" & prmNomTable & "].lot, [" & prmNomTable & "].uv, [" & prmNomTable & "].dlc, [" & prmNomTable & "].bon, [" & prmNomTable & "].colis, [" & prmNomTable & "].poids, [" & prmNomTable & "].code, [" & prmNomTable & "].Nom, [" & prmNomTable & "].Douchage, [" & prmNomTable & "].sscc FROM [" & prmNomTable & " ]"
' q.SQL = "Select [" & prmNomTable & "].* from [" & prmNomTable & "]" 'Ici le nouveau SQL
Set q = Nothing 'Libère explicitement la mémoire utilisée
db.Close: Set db = Nothing 'Libère explicitement la ressource et la mémoire utilisée
End Sub |
Partager