Adding Records To A Table Using ADO?

Hi can anyone explain or give example code to add records to a table using ADO. I am using VB6 and have set up a Data Environment, Connection, and Commands that refer to tables.

Cheers

Jonny

Thanks Ian

I'll play around with some of those code examples to see which one best suits.

Cheers

Jonny

Just use a standard SQL statement will do.

Code:

---

INSERT INTO <Table Name> VALUES (bla...bla...bla...);

---