You are missing an ampersand, double quotes, your delimiters are wrong and you don't need the parenthesis in the VALUES clause:
Your way:
Code:
strSQ = "INSERT INTO FactureInside(FactInsideId,factInsideDate,produitNom,prixvenduI,quantiteSortiI)" & _ '<-missing ampersand and double quote at the end
" VALUES (" & fact & ", #" & factdate & "#, " & prixvendu & ", " & quantite & ");" '<-missing double quote before VALUES
I prefer to create SQL strings like this:
Code:
strSQ = "INSERT INTO FactureInside(FactInsideId,factInsideDate,produitNom,prixvenduI,quantiteSortiI)"
strSQ = strSQ & " VALUES (" & Fact & ", #" & factdate & "#, " & prixvendu & ", " & quantite & ");"