Programming in VB.NET! Help needed.

[Master_Key]

I have a table in access, it is linked to vb.net by jet oledb provider. I want to move all the records of this table to a new table which may already contain records. I have to move all the records of table 1 to table 2 at the 1st of every month. Table 2 may contain records, these should not be deleted.

Can anyone help with archiving of these records. Any help will be appreciated.

[minty777]

just perform an append operation so the new group of rows from table 1 are simply added on to the end of table 2 - it will mean table 2 will become massive after a while but it works

[Master_Key]

Originally Posted by minty777

just perform an append operation so the new group of rows from table 1 are simply added on to the end of table 2 - it will mean table 2 will become massive after a while but it works

I have security measures for data. The table should also contain records as old as a year. Thank you.