Copy a record in access using ADO and an SQL string

[Tom Allitt]

I am trying to copy a record held within an access database and create a new one from it using unbound data with ADO. How can I do this using a SQL string?