I need sample code in VB using either ADO(preferable) or ADO.net to
read 10000 records from one database and write these records to
another database.

However when I am writing the records to the other database I do not
want to commit each record. I want to write all the records at the
end as one big transation.

I read something in the documentation about turing off autocommit,
but I was unsure how to use this code.