Efficient VB.NET Table Archiving: Move Records Between Tables Monthly

  • Thread starter Thread starter Keyur
  • Start date Start date
  • Tags Tags
    Programming
Join the discussion
Registration is free. Ask a follow-up in this thread, or start your own.
Sign up Log in
4 replies · 2K views
Keyur
Messages
10
Reaction score
0
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.
 
Physics news on Phys.org
To another table within the same access database?
 
DavidSnider said:
To another table within the same access database?

Yes, the same access database.
 
The GUI can help you with this. You need what's called an Append Query. If you write this successfully, you can save it and re-run it anytime you want to.
 
harborsparrow said:
The GUI can help you with this. You need what's called an Append Query. If you write this successfully, you can save it and re-run it anytime you want to.

Done with it.

THANK YOU ALL.
 

Similar threads

Moving records between tables in MS Access
  • adjacent
  • · Replies 1 ·
  • Computing and Technology
Replies
1