Voici mon code de base:create table AGV
(CODEAGV numeric(10) not null,
REF char(20) not null,
UTILISATEUR char(6) null ,
TYPOPER char(1) null ,
DATOPER datetime null ,
OBSERVATION char(250) null ,
OFFID char(10) null ,
NOM_AGV char(20) null ,
FAX char(20) null ,
TEL char(20) null ,
VILLE char(20) null ,
DIRECTION char(20) null ,
AGVDATEINST datetime null ,
AGVSTATUS char(20) null ,
constraint PK_AGV primary key (CODEAGV) )
ma requete ne marche pas:strsql = "Insert into AGV (CODEAGV,REF,UTILISATEUR,TYPOPER,DATOPER,OBSERVATION,OFFID,NOM_AGV,FAX,TEL,VILLE,DIRECTION,AGVSTATUS,AGVDATEINST) values ('" & txt1 & "','" & txt2 & "','" & txt3 & "',getdate(),'" & txt5 & "','" & txt6 & "','" & txt7 & "','" & txt8 & "','" & txt9 & "','" & txt10 & "','" & txt11 & "','" & txt12 & "','" & txt14 & "','" & txt13 & "' )"