Programming in VB.NET! Help needed.

Master_Key

Solid State Member
Messages
6
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.
 
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
 
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.
 
Back
Top Bottom