add record to table

[Bullsandbears123]

I have a table "tblcontacts". I would like to add a record and insert values into it with out using a form just VB. It this possible.

tblcontacts:
[name]is text [address]is text [phone]is number


Is there a command I can use in insert value into the recordset.
for example :
docmd.addrecord(john,1234street,5555555555)

or something like this.

Thanks

 

[TLady]

sql="Insert values("1","2&quot into Table1(Col1,Col2)"
DB.Execute sql
or
DB.Execute "Insert values("1","2&quot into Table1(Col1,Col2)"

TIA

 

[Bullsandbears123]

THANKS THIS IS GREAT!