This is a basic task, but I can't seem to find an example
of how to do it:

I want to scan through the records in table 1 and move
(insert) that data along with other static info into the
records of another table. How do I do this with ADO.Net?

The tables are Access 2000 tables.

Thanks