I need to know the best way to code using vba to read a few records from an
Sql database(one table), modify these records then add them as new records to
the same table.

Thanks,

If VBA supports accessing a database, then you can read the records from the
table into a record set and then iterate over the record set and make your
changes. Finally, you can then insert each of these records into the table
again. There are 100's of examples of using ADO and RecordSet that you can
search for.
Show quoteHide quote

multiple inserts in transaction
Joing two tables but avoid cartesian product
Dynamic SQL Column Total Help
Datetime constraint: is there a better way to do this?
Add a field