serv_db = "127.0.0.1" datbase = "essai" ' nom de la base de données user_db = "root" pwd_user_db = "" option_db = 35 Set connex = New ADODB.Connection connex.CursorLocation = adUseServer connex.Open "DRIVER={MySQL ODBC 3.51 Driver};SERVER=127.0.0.1;DATABASE=" & datbase & ";USER=" & user_db & ";PASSWORD=" & pwd_user_db & ";OPTION=35" rs_sql = "Select * From categorie" 'requete de selection Set rs_sub = New ADODB.Recordset rs_sub.ActiveConnection = connex rs_sub.Open rs_sql, connex, adOpenDynamic, adLockOptimistic Do Until rs_sub.EOF Debug.Print rs_sub!designation 'affichage du resultat selon les champs de table rs_sub.MoveNext Loop