Hi Fbonnard,

But i don't know how to proceed with
one recordset.

Just to (hopefully) clarify things, you only open and close recordsets
when your SQL returns values (i.e. your SELECT statement). For the
INSERT and UPDATE, you 'Execute' the SQL using the ADO Connection
object, rather than a Recordset object.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk